ERROR at line 6: PL/SQL: Statement ignored
432643Sep 2 2005 — edited Sep 2 2005The above error is generated when I try to create a trigger in the SQL workshop.
To explain, this was the first App I created with HTMLDB and the Insert Update form has not been used (I forgot to test it) until today. I traced the problem to an invalid trigger, on closer inspection it appeared that the trigger was invalid because I had deleted the sequence that it referenced.
I created the sequence again and then tried to create a trigger with the PL/SQL
for c1 in (
select "TECHCONTACTS_SEQ".nexval next_val
from dual
) loop
:new."ID" := c1.next_val;
end loop;
My only solution is to re-create the whole application from scratch after deleting all the sequences and triggers that were used.
Can anybody tell me why I cannot successfully make a new trigger in HTMLDB 1.6 ?
TIA
John
Message was edited by:
mpleydell@nwoca.org