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.
Subject
Views
Written By
Posted
1966
February 08, 2006 02:53PM
1264
February 08, 2006 05:18PM
Re: is sqlstate value availableinside the procedure ?
1301
February 08, 2006 06:09PM
1323
February 09, 2006 09:02PM
1335
February 11, 2006 12:52PM
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.