Re: Trigger on Sequence

CREATE SEQUENCE test_seq;

SELECT test_seq.NEXTVAL FROM dual;

CREATE OR REPLACE
FUNCTION get_nextval RETURN INTEGER IS
  lv_ret_val INTEGER;
BEGIN

• hire can be your code
• for example: Raise_Application_Error(-20999,'Sequence isn't accessible');

  SELECT test_seq.NEXTVAL INTO lv_ret_val FROM dual;

• hire can be your code

  RETURN lv_ret_val;
END;
/

SELECT get_nextval FROM dual;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 17 1999 - 06:10:28 CDT