Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> create sequence problem !! pls help
is it possible to do this?
create sequence Test
start by x
increment by 1
cache 1000;
where x is a variable which is determined in a PL/SQL procedure
CREATE OR REPLACE PROCEDURE findID
( x OUT SMALLINT) AS
v_max Test.ID%TYPE;
BEGIN
SELECT max(id) INTO v_max FROM Test; x:=v_max;
Thx in advance Received on Sun Dec 29 2002 - 16:53:14 CST