Need to pass return code from stored proc to DBI

[pavery]

I need to call a stored proc (Sybase) from Perl using DBI. The stored proc will pass back a return code (0 or 1). I can't see how this is done...all the examples I see in the O'Reilly DBI book reurn rows from a stopred proc not a return code.

Does anyone have some sample code (both the stored proc code & the Perl code) of how to do this?

Thanks, Pat

 

[MikeLacey]

Pat,

Couldn't you just pass back a single row with a single column that contains your return code?

You could read the value the same way you read values from returned rows. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.