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

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?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://665980]
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
Find Nodes?
    Voting Booth?

    No recent polls found