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: Torsten Bauer <perl at torsten-bauer dot de>
Subject: Re: stored procedure and return values
Date: Oct 12 2005 3:03PM

hi peter,

isql for example returns -6 as the result status and i thought i can 
catch this with sybperl.....

and $DBI::errstr is empty after my loop...?

thanks
torsten

Peter Sinnott schrieb:

>On Wed, Oct 12, 2005 at 03:09:13PM +0200, Torsten Bauer wrote:
>  
>
>>hi all
>>
>>when i run the procedure proctest with isql the return status is -6.
>>
>>i try to catch this in perl but i can't get it.. i used different ways 
>>and this is the latest one - based on the documentation:
>>
>>has someone an idea what i do wrong? it seems i'm going mad..
>>
>>    
>>
>
>I imagine since the execute fails there will be nothing useful on
>the statement handle.
>
>What do you need the return code for?
>
>If you need to trap the error the execute fails and $DBI::err is set to 208(missing object)
>
>http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/12631
>
>
>Unless you need to get the same return code from isql and perl this should be enough.
>
>  
>