Re^3: how to import sql file into oracle database.

[agianni]

in reply to Re^2: how to import sql file into oracle database.
in thread how to import sql file into oracle database.

Here's your problem:

foreach my $stmt( @statements ){
$dbh->do($_); }

There are a couple of things wrong. First, your code is trying to execute the SQL one line at a time. So the first SQL command you are running is:

Create table xyz (

which generates the error you're seeing. jZed's advice on splitting on semi-colons and re-joining should work.

Also, you're naming your variable for the loop but then you are referencing $_, which may or may not work correctly.

[koleti]

this is the error i am facing now
Placeholder :0 invalid, placeholders must be >= 1 at C:/Perl/site/lib/DBD/Oracle .pm line 262, <SQL> line 10009.

[Anonymous Monk]

If your SQL has anything preceeded by a colon (eg :01) then the oracle interprets it as a placeholder, to be filled using bind calls of some description.