in reply to SQL Scripts with PERL

DBI abd DBD::Oracle can only execute one SQL command per prepare() call. If I'm guessing correctly your SQL script files contain multiple SQL statements, in which case you will have to parse your SQL script file so that you execute each command separately.

Michael

Replies are listed 'Best First'.
Re: Re: SQL Scripts with PERL
by Anonymous Monk on Dec 31, 2003 at 19:57 UTC

    No. The OP script is preparing and executing each line of the external file.

    Unless a line contains more than one statement, it seems to me that the only mistake is the one outlined by duff.

[reply]

In Section Seekers of Perl Wisdom