• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to handle RAISEERROR in Sybase using JDBC

 
Skarol robert
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys,

I am trying to access a Sybase stored procedure thru JDBC where that Procedure has many debug messages using "RAISEERROR 22000".
Ex:
[
select @str = "You are in the first line of the procedure"
RAISEERROR 22000 @str
.....]


When I am trying to call the SP using Callable statement the control is comingout as soon as it encountering the first "RaiseError block".

Is there anyway to supress these messages ,so that the control will till the last line of the SP.

Any help is appreciated.

Thanks in advance !!
 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys anybody has idea about this. I am having same problem.
 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using sybase jdbc driver jconnect. The stored proc code cannot be modified to use PRINT.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic