in reply to DBI Oracle insert not working

There are things missing from this example like the fact you have called commit but we don't know if you disabled AutoCommit or if you are really in a transaction. However, don't concatenate strings into sql, use bound parameters instead and I'd look carefully at your strings and column types as you are using some with leading and trailing white space.

Replies are listed 'Best First'.
Re^2: DBI Oracle insert not working
by smoky (Novice) on Apr 02, 2009 at 11:12 UTC
    Hey .. Sorry that I didn't meantion about the commits.. I have tried both auto commit and manual commit without any luck :( I shall try bounding the parameters now
[reply]

      You should always use bound parameters and not concatenate strings - there are multiple reasons why, commented on perl monks many times before and in the DBI documentation too. The only thing I can think of from the code snippets you provide is that the insert into repository is rolled back or not in the same connection and not committed or in different schemas as the insert for 'testSQL' seems to match the select for 'testSQL'.

[reply]

In Section Seekers of Perl Wisdom