Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

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.

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, :-)