Re: Question on proc execution with sybperl

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.
[email protected]                       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