in reply to Re^7: how could i insert data from a file to oracle database
in thread how could i insert data from a file to oracle database

The problem is you are still passing $_ to $dbh->do when you assign each statement to $stmt in the foreach loop. Use $dbh->do($stmt). That's what the "invalid length specified for statement" messages is about.

---
echo S 1 [ Y V U | perl -ane 'print reverse map { $_ = chr(ord($_)-1) } @F;'
Warning: Any code posted by tuxz0r is untested, unless otherwise stated, and is used at your own risk.

  • Comment on Re^8: how could i insert data from a file to oracle database

In Section Seekers of Perl Wisdom