Re: DBI Deletes with placeholders

[talexb]

Regarding your post, it's customary to wrap code sections in <code> tags. If you could update your post, that would be appreciated.

Regarding your DBI question, why don't you ask DBI what the problem is by outputting DBI->errstr in your error message, rather than a generic message? Also, I typically make a connection with RaiseError => 1

Another thing to check is whether the user you're connecting to the database as, has sufficient privilege to delete table rows.

[AKSHUN]

DBI doesn't return any error. The code runs successfully, but the data remains in the database. I connect manually using SQLPLUS and I can see that the data is still there. I have the necessary privs on the database because I can delete them manually with a query.

I believe the problem is that I am not properly using placeholders.

[Corion]

In principle your code and SQL should work. One more thing you can try is to change your SQL from using DELETE to using SELECT - my guess is that your value in $var is wrong.

Maybe the id column is a CHAR column instead of a number? Is the code you posted the actual code you're running? Maybe you can show us the real, actual code (minus the login to Oracle) you're using?