How do i get seq.nextval from within a pl/sql function

ljordan · #1 (**permalink**) 02-18-04, 17:57

Hi,

Im using Oracle 9i and writing a PL/SQL function and i need to get the sequence.nextval within the function. I am getting an error saying sequence does not exist. I have tryed the following :

select mySeq.nextval
into v_myvar
from dual;

but I still get the same error message. Is there any way to get the next value in a sequence from within a PL/SQL function.

Any help would be greatly appreciated.
Thanks

Littlefoot · #2 (**permalink**) 02-19-04, 03:20

PHP Code:


			
CREATE SEQUENCE myseq;



CREATE OR REPLACE FUNCTION fun_seq

   RETURN NUMBER

AS

   retval   NUMBER;

BEGIN

   SELECT myseq.NEXTVAL

     INTO retval

     FROM DUAL;



   RETURN (retval);

END;

/



SELECT fun_seq FROM DUAL;



FUN_SEQ

-------

      1