Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^2: perl script to delete or update an ORACLE table hangs during execution

by prashantktyagi (Scribe)
on Jun 05, 2012 at 11:34 UTC ( #974435=note: print w/ replies, xml ) Need Help??


in reply to Re: perl script to delete or update an ORACLE table hangs during execution
in thread perl script to delete or update an ORACLE table hangs during execution

hi, Can try DML query with 'NOLOCK' to check if any deadlock is there.


Comment on Re^2: perl script to delete or update an ORACLE table hangs during execution
Re^3: perl script to delete or update an ORACLE table hangs during execution
by davido (Archbishop) on Jun 05, 2012 at 18:52 UTC

    How about trying { RaiseError => 1} like I suggested. I still haven't seen from the code you posted that you're actually doing error checking. Without error checking, you don't get the help provided by error messages. Why look at locking when you haven't even looked to see what errors you're getting?

    When you go to the doctor and say, "My chest hurts.", he will probably want to run some tests. He has in his mind tests that will help him to identify the problem. It could be that the tests will come back inconclusive. But often they provide insight to the problem you're having. If you refuse to let him run the tests, he can't narrow down why you're having chest pain. He could offer you this pill or that suggestion, but his suggestions could be way off if he hasn't had an opportunity to run some tests on you.

    I suggested turning on error checking so that you could get some diagnostic information. The diagnostics may be inconclusive. But on the other hand, they could point right to the problem, in which case there needn't be any guesswork in finding a solution.


    Dave

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2014-12-21 10:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (104 votes), past polls