Keep It Simple, Stupid | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I'm trying to do a database deletion from an Oracle database. I'm using DBI and the Oracle DBD. I can do inserts with placeholders, but I do not know how to do deletes.
I declare my variable like this.
I originally tried using prepare and execute statements, but to no avail. Then I thought that I should use a "$dbh->do" call, but I don't know how to make it work with placeholders. Can anyone assist? UPDATE: Corion prompted me to check the type of the column that I was using in the where clause. It was a CHAR(6). I was looking for a 5 character string. I padded the string with a trailing space and everything worked properly. Gentlemen(and/or ladies), thank you for your help. AKSHUN In reply to DBI Deletes with placeholders by AKSHUN
|
|