Re: how to invoke .sql file from dbi

On Wednesday 24 May 2006 22:11, mark wrote:
ravi kongara wrote:
But it is little surprising that dbi doesn't support executing sql files
directly.

What you are calling "sql file" is actually an *Oracle SQLPlus file*.

Maybe DBD::Oracle could have a SQLPlus emulation mode, but even if
such a beast existed, it would certainly not be part of *DBI*.

Mark

<rant mode="on">
What I find surprising is the amount of DBAs who, driven by standard Oracle
tools' limitations, hear about this "powerful Perl/DBI thing", assuming that
their Oracle/shell script skills will be enough to handle the migration, and
then complaining and blaming DBI when something does not work the way they
expected it work... *sigh*
</rant>
.