MySQL Forums
Forum List  »  Stored Procedures

Re: is sqlstate value availableinside the procedure ?
Posted by: Claudio G
Date: February 08, 2006 06:09PM

yes...but

how i get the SQLSTATUS value within de proc ?

===============================
create procedure p1 (out my_sqlstatus integer,id integer,s varchar(20))
begin
...
insert into t1 values(id,s)
set my_sqlstatus = SQLSTATUS (??)
==============================

or how can i test the value of SQLSTATUS within the procedure ?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: is sqlstate value availableinside the procedure ?
1301
February 08, 2006 06:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.