PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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.



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