SV: Nextval in trigger

From: Jesper Haure Norrevang <jhn.aida_at_cbs.dk>
Date: Tue, 27 Jan 2004 01:14:26 -0800
Message-ID: <F001.005DE2A5.20040127011426@fatcity.com>

Hi Roland,

Create the sequence before using it, e.g.:

create table system_change(ID number);
create sequence system_change_id;
Insert into system_change values(system_change_id.nextval); select * from system_change;

Regards
Jesper Haure Nørrevang

-----Oprindelig meddelelse-----
Fra: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] På vegne af roland.skoldblom_at_ica.se
Sendt: 26. januar 2004 13:24
Til: Multiple recipients of list ORACLE-L Emne: Nextval in trigger

Hallo,

I would like to make an insert statement into a table in atrigger, Iam trying to do:

Insert into system_change values(system_change_id.nextval) but it gives me an error message which tells me that I havent declared any sequence. How can I fix this ?

Thanks in advance.

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: roland.skoldblom_at_ica.se

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesper Haure Norrevang
INET: jhn.aida_at_cbs.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------