Re: how to import sql file into oracle database.

[jZed]

in reply to how to import sql file into oracle database.

Try something along the lines of this (assumes SQL statements are terminated by semicolon+newline)

...
open( SQL, 'somefile') or die $!;
my @statements = split(/;\n/,join('',<SQL>));
for my $stmt( @statements ){
    $dbh->do($_);
}