in reply to Re^3: Oracle Insert with DBI
in thread Oracle Insert with DBI

Yes the issue is, in fact, that my sql string seems correct,
yet the inserts do not happen after running the script
the database still remains empty.

Its a very elusive issue that I cant seem to resolve.

Replies are listed 'Best First'.
Re^5: Oracle Insert with DBI
by mje (Curate) on Jan 13, 2010 at 09:45 UTC

    Are you absolutely sure you are not in a transaction? Even if you use AutoCommit in the connect call somewhere else can use begin_work to disable autocommit in a block say. You could perhaps try DBIx::Log4perl which only logs DBI method calls which would make your tracing smaller but hopefully sufficient to see whether the row should have been inserted. It should be trivial to add to your code as only the connect call will need to change.