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 220.127.116.11 ASE with
> the below code.
> $dbhS->ct_sql("exec $opt_D..proc_arch_mt $glun"); ## Archive this
> 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");
> 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
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 Peppler Data Migrations, Inc.
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html