SV: Oracle Sequence Numbers

[=?iso-8859-1?Q?=22Selfors=2C_Bj=F8rn=22?=]

Darren!
Try using a stored procedure in the database and: 

 sql call xxxxx.nextno (rno out) 
in a procedure in qdesign

Bjørn Selfors.

-----Opprinnelig melding-----
Fra: Darren Reely [mailto:darren.reely@latticesemi.com]
Sendt: 25. april 2002 20:30
Til: 'powerh-l@lists.swau.edu'
Emne: Oracle Sequence Numbers


Hi all,

Is there anyway to implement the following cursor so I can have the 
database return a sequence number.

sql in mfg declare myseq cursor for &
       select trays_seq.nextval from dual

cursor myseq designer


Platform:
Using PH 8.13.D1
Solaris
Oracle 7.3.4.4.0

Darren,

Thank you.



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.