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: Question on proc execution with sybperl
Date: Sep 24 2004 5:38AM

On Thu, 2004-09-23 at 21:57, Sabherwal, Balvinder (MBS) wrote:

> I have a script that is executing a proc on Sybase 12.5.0.3 ASE with
> the below code. 

> $dbhS->ct_sql("exec $opt_D..proc_arch_mt $glun");  ## Archive this
> GLUN
> 
>    if ( defined($errmsg) )         ## Make sure there were no errors
> in the last sql execution.
>    {
>       msg_send("$opt_N","MT_Arch.pl Failed for $opt_D on $opt_S " ,
> "Script failed due the errors below.\n$errmsg\n","$mailto","$pto");
>       exit(1);
>    }

> Upon execution, It fails with the error message as below. Can some one
> point me to the solution so I do not get this message back?

>          Script failed due the errors below.
> 
>  Procedure proc_arch_mt 

There's not enough in the code snippet above to determine why $errmsg
gets set.

My guess is that you need to define a server callback or change the one
you already have to ignore certain types of messages from the proc.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html