Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^2: DBI Deletes with placeholders

by AKSHUN (Novice)
on Feb 04, 2008 at 15:25 UTC ( #665980=note: print w/replies, xml ) Need Help??


in reply to Re: DBI Deletes with placeholders
in thread DBI Deletes with placeholders

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.

Replies are listed 'Best First'.
Re^3: DBI Deletes with placeholders
by Corion (Patriarch) on Feb 04, 2008 at 15:39 UTC

    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?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://665980]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (3)
As of 2022-08-12 18:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?