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: Narasayya Immid <narasan at yahoo dot com>
Subject: Re: DBlib ErrorHandler question...
Date: Mar 24 1999 1:53AM

Thanks Michael for your reply.

- Narasayya
----------------------------------------------------
--- Michael Peppler  wrote:
> Narasayya Immid writes:
>  >     Can anyone tell me when there is an database
> error,    (trigger
>  > error, query syntax error... ),
>  > for what type of database errors  "ErrorHandler"
> function will be
>  > called, and for what type of database errors
> "MessageHandler" function
>  > will be called?
> 
> The MessageHandler will be called for all Sybase
> errors.
> The ErrorHandler will also be called for these
> errors, but with a
> generic message that we don't really need to see, so
> this is the
> reason for these lines in the error handler in
> sybutil.pl:
> 
>     if ($error != SYBESMSG) {
> 	print STDERR ("Sybase error: ", $error_msg, "\n");
> 	print STDERR ("OS Error: ", $os_error_msg, "\n") if
> defined ($os_error_msg);
>     }
> 
> This inhibits the error handler from printing
> anything if it's a
> Sybase error.
> 
> For other types of errors (specifically operating
> system errors) only the
> error handler will be called.
> 
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@peppler.org    -||- 
> http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com
> 
> 

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com