> If it's possible to return the next sequence number > ([<owner>.]<sequence_name>.NEXTVAL) from a stored > procedure could someone post an example? I'd like to > do something like:
> CREATE DBPROC next_num(OUT num SMALLINT) AS > VAR num SMALLINT; > SET num = dba.myseq.NEXTVAL > This doesn't work for me. Can it be done? Hi, this should work CREATE DBPROC next_num(OUT num SMALLINT) AS select myseq.NEXTVAL into :num from sysdba.dual ; Regards, Holger
