APEX

The 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