Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> foocounter.CURRVAL

foocounter.CURRVAL

From: Frank <franjoe_at_frisurf.no>
Date: Thu, 15 Mar 2001 16:51:29 +0100
Message-ID: <GC5s6.241$ph3.1503@news1.oke.nextra.no>

Hi!

foocounter.currval will contain the last generated sequence no after you have inserted.

Before ANY number is generated in the current session, you will get the message:

"ORA-08002: sequence foocounter.CURRVAL is not yet defined in this session"

Frank

eg.
SELECT foocounter.currval
FROM DUAL; Received on Thu Mar 15 2001 - 09:51:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US