Database Administration (MOSC)

MOSC Banner

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 ;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center