sybperl-l Archive

From: abe dot crabtree at citicorp dot com
Subject: Re: Why doesn't error_handler get called if errors occur inside a s tored procedure?
Date: Dec 7 2001 3:54PM

PRINT results in a Server Message of severity 10 (information,) so you have to 
have a message handler.

It isn't immediately obvious that they are messages, because one is used to 
isql simply printing them, whereas the messages we see reported with numbers, 
severities, procedure name and text are deliberately reported more extensively 
by isql (which is after all just a database client.)

So typically your message handler would just display the message text for a 
severity 10 or less, and do real error handling for anything worse.

Regards

Abe Crabtree

-----Original Message-----
From: Matthew.Persico [mailto:Matthew.Persico@Lazard.com]
Sent: 07 December 2001 14:51
To: SYBPERL-L
Cc: Matthew.Persico
Subject: Re: Why doesn't error_handler get called if errors occur inside
a stored procedure?



So what happens these days if you do not establish your own message handler? I'm
especially interested in the disposition of print statements in stored procs.

Much obliged.

---------------------------------------------------------------------------
Matthew Persico
Vice President
Lazard
30 Rockefeller Plaza
New York, NY 10020, USA
Phone Number: 212 632 8255
Fax Number: 212 332 5904
Email: matthew.persico@lazard.com
---------------------------------------------------------------------------