A.barth
09-05-2003, 05:42 AM
Hi,
I think the use of a bind variable is not the right choice.
Replacing that by a normal variable (declared before the BEGIN) should
fix your problem.
For example:
CREATE SEQUENCE count_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 999999
NOCYCLE;
create or replace TRIGGER "USER".mytrigger1
AFTER INSERT
ON mytable1
FOR EACH ROW
declare
l_id NUMBER;
BEGIN
SELECT count_seq.nextval INTO l_id FROM dual;
INSERT INTO mytable2 values (l_id);
END;
/
--
Posted via http://dbforums.com
I think the use of a bind variable is not the right choice.
Replacing that by a normal variable (declared before the BEGIN) should
fix your problem.
For example:
CREATE SEQUENCE count_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 999999
NOCYCLE;
create or replace TRIGGER "USER".mytrigger1
AFTER INSERT
ON mytable1
FOR EACH ROW
declare
l_id NUMBER;
BEGIN
SELECT count_seq.nextval INTO l_id FROM dual;
INSERT INTO mytable2 values (l_id);
END;
/
--
Posted via http://dbforums.com