sybperl-l Archive

From: Alex Quezada <Alex dot Quezada at cnet dot com>
Subject: How to get SP error messages
Date: Jul 23 2002 12:53AM

Hi,

	I'm using Sybase::DBlib to execute an SP, and this SP returns an error message:

couser-SF_CON_DEV1 1>EditElement @elementId=953684, @userId=100;
Msg 20023, Level 16, State 1
Server 'SF_CON_DEV1', Procedure 'EditElement', Line 76
Alex Quezada already has that 953684 checked out.
(return status = -114)

So I'd like to pass this error message along, but for the life of me I can't find the method to read the error message.  I can grab the return status just fine, but that isn't enough since it doesn't give me the error details (like who has checked stuff out).

Anyone know what method I can use to grab this info?

	thanks!

		Alex Quezada