Oracle Sequence Numbers

[Bert de Nooij]

Hi Darren,

Another possibility is a trigger
Something like this:


TRIGGER TABLE_STR1
before INSERT  ON TABLE
   FOR each ROW
declare l_seqno  number ;
begin
  select TRAYS_SEQ.nextval
  from dual
  into l_seqno
  NEW.ITEM_IN_TABLE   := l_seqno
END;


regards,

Bert

-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Selfors, Bjørn
Sent: vrijdag 26 april 2002 9:20
To: Darren Reely; powerh-l@lists.swau.edu
Subject: SV: Oracle Sequence Numbers


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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.