I am trying to access a Sybase stored procedure thru JDBC where that Procedure has many debug messages using "RAISEERROR".
select @str = "You are in the first line of the procedure"
RAISEERROR 9999 @str
When I am trying to call the SP using Callable statement the control is coming out as soon as it encountering the first "RaiseError block".
Is there anyway to supress these messages, so that the control will execute till the last line of the SP. I know about using PRINT instead of RAISEERROR but it is not possible to change the stored procedure code.
I am using sybase jdbc driver jconnet.