Oracle sequence generator

How to write stored procedure,which take the sequence name as input and dynamically generates a nextval from that sequence

Showing Answers 1 - 3 of 3 Answers

Ashish

Jul 30th, 2014

Code
CREATE OR REPLACE Procedure P_Get_Value( seqnm IN Varchar2) IS 


  L_Var Varchar2(100);


  TYPE cur_typ IS REF CURSOR;


  c cur_typ;


Begin


  OPEN c FOR SELECT  || seqnm ||


      .NEXTVAL FROM Dual;-- USING seqnm;


  Fetch c INTO L_Var;    


  Close c;


  dbms_output.put_line(nextvalue:  || L_var);


End; 


----- to execute


Begin


   P_Get_Value(&seqnm);


End;