Retrieve a sequence number using a cursor
From: reza <reza_at_dircon.co.uk>
Date: 1999/01/07
Message-ID: <3694BBD9.389ACF46_at_dircon.co.uk>#1/1
Date: 1999/01/07
Message-ID: <3694BBD9.389ACF46_at_dircon.co.uk>#1/1
BODY:
CREATE OR REPLACE PACKAGE BODY pkg_unique
AS
PROCEDURE allunique
(SYS_DEF_SEQ OUT t_sysno
)
IS
CURSOR cur_key IS
SELECT SYS_DEF_SEQ.NEXTVAL FROM dual;
sccount NUMBER DEFAULT 1;
BEGIN
FOR thing IN cur_key
LOOP
SYS_DEF_SEQ(sccount):=thing.SYS_DEF_SEQ;
sccount:=sccount+1;
END LOOP;
END;
END;
Received on Thu Jan 07 1999 - 00:00:00 CET