|
|
sybperl-l Archive
Up Prev Next
From: Naveen_Rajavasireddy at ACML dot COM
Subject: Re: message_handler
Date: Jan 21 1998 6:27PM
01-21-98 02:27 PM
Naveen Rajavasireddy @ ALLIANCE CAPITAL
Naveen Rajavasireddy @ ALLIANCE CAPITAL
Naveen Rajavasireddy @ ALLIANCE CAPITAL
01-21-98 02:27 PM
01-21-98 02:27 PM
Okay, please ignore my question from below?
I understand that the message hadler is invoked only when there is some
error to be reported back
to the program.
To: SYBPERL-L@trln.lib.unc.edu
cc:
Subject: message_handler (Document link not converted)
How do I reset the message_handler?
1) Installed the message_handler in my program.
2) Insert SQL statement 1 for table A
Before the execution of next statement, I create a deadlock situation by
running a program in a
different session.
3) Insert SQL statement 2 for table B
4) The above command becomes a deadlock victim and fails.
5) Program loops back and starts from step 2 on looking at the 1205 message
My problem is that after the fail on step 3, my variables from the message
handler are still that of deadlock
even though, I insert into the database successfully.
Naveen Rajavasireddy, :-)
|
