Up Prev Next
From: Alex Quezada <Alex dot Quezada at cnet dot com>
Subject: How to get SP error messages
Date: Jul 23 2002 12:53AM
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?