plodna_zemlja has asked for the wisdom of the Perl Monks concerning the following question:

I've been using DBI with DBD::Oracle for about 2 years for select & inserts, but now I'm trying update and it doesn't work. I can give the sql in SQL-Plus and it works right away, but from perl it just hangs doing apparently nothing forever. What I think might be meaningful is that if the condition is false, it completes immediately, but when it is true it hangs:

UPDATE table
SET column=value
WHERE condition

After playing with formatting for a few hours and searching the net for help I am looking for some wisdom from the monks.
Thanks

Replies are listed 'Best First'.
Re: Can't Update/Delete in Oracle
by mifflin (Curate) on Oct 01, 2004 at 18:18 UTC
    Sounds like you are trying to update a locked record. Make sure you don't have it locked in your sqlplus session.
[reply]
      Well...(beating myself over the head with my coffee mug) not that session I was checking with. That's what I get for working on the same thing from 5 computers at the same time. Yes it was locked, which seemed like the most likely solution, I just hadn't checked everything I had going.
      Thanks
[reply]
Re: Can't Update/Delete in Oracle
by dragonchild (Archbishop) on Oct 01, 2004 at 18:18 UTC
    What is the exact Perl you're using? What is the exact SQL you're using? It sounds like you're missing something very slight, but there's like 10 things that could be going wrong.

    Being right, does not endow the right to be rude; politeness costs nothing.
    Being unknowing, is not the same as being stupid.
    Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
    Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

[reply]

Back to Seekers of Perl Wisdom