Re: Sequence error

From: Wim Valgaeren <valgaeren_at_softhome.net>
Date: Thu, 4 Nov 1999 16:10:38 -0000
Message-ID: <7vs78f$j3j$1_at_naxos.belnet.be>


You have to do INSP.SEQ_BSC_INSP_ID.NEXTVAL before you can do a currval.

Greetings,
Wim Valgaeren
Phill Weiss <weiss_at_cig.mot.com> wrote in message news:7vs4md$jj22_at_nntp.cig.mot.com...
>
> I have a sequence which I know exists by the following query:
> select sequence_owner, sequence_name from all_sequences where
sequence_owner = 'INSP';
> which returns
>
> SEQUENCE_OWNER SEQUENCE_NAME
> ------------------------------ ------------------------------
> INSP SEQ_BSC_INSP_ID
>
> Yet, when I do a select INSP.SEQ_BSC_INSP_ID.CURRVAL from dual:
>
> I get the following error:
> ERROR:
> ORA-08002: sequence SEQ_BSC_INSP_ID.CURRVAL is not yet defined in this
session
>
>
>
> no rows selected
>
> Anyone know what I'm doing wrong? Thanks for any help.
Received on Thu Nov 04 1999 - 17:10:38 CET

Original text of this message