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: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Why doesn't error_handler get called if errors occur inside a stored procedure?
Date: Dec 7 2001 4:31PM

Matthew.Persico@Lazard.com writes:
 > 
 > 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.
 > 

In Sybase::DBlib?

Right now it seems that PRINT statements are simply discarded, because
of the following in DBlib.xs msg_handler() function:

    
    /* Don't print any message if severity == 0 */
    if(!severity)
	return 0;

That should probably be something like

     if(!severity && !msgno)
         return 0;

with some other fixes as well to handle the default case.

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com