Hi, 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? Thanks, Ray Drew __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com
