Sequence error
From: Phill Weiss <weiss_at_cig.mot.com>
Date: 4 Nov 1999 14:19:57 GMT
Message-ID: <7vs4md$jj22_at_nntp.cig.mot.com>
Date: 4 Nov 1999 14:19:57 GMT
Message-ID: <7vs4md$jj22_at_nntp.cig.mot.com>
[Quoted] I have a sequence which I know exists by the following query: select sequence_owner, sequence_name from all_sequences where sequence_owner = 'INSP'; [Quoted] 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
[Quoted] no rows selected
Anyone know what I'm doing wrong? Thanks for any help. Received on Thu Nov 04 1999 - 15:19:57 CET