http://qs321.pair.com?node_id=650567


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($_); }