ORA-00900: invalid SQL statement during auto query optimization in TOAD
Hello everyone, can someone help me and tell me where the issue is with the syntax in this DDL for creating triggers?
CREATE OR REPLACE TRIGGER TR_FACETTENZUORDNUNGEN_R
after insert or update or delete on facettenzuordnungen_r
referencing old as old new as new
for each row
DECLARE
cursor c_loop_ins is select *
from hierarchie_v where version_id = :new.version_id and aenderungstyp <> 2 start with eintrag_id = :new.eintrag_id connect by prior eintrag_id = vater_eintrag_id ;
cursor c_loop_del is select *
from hierarchie_v where version_id = :old.version_id and aenderungstyp <> 2 start with eintrag_id = :old.eintrag_id connect by prior eintrag_id = vater_eintrag_id ;