Loading ...
Sorry, an error occurred while loading the content.

RE: [SQLQueriesNoCode] Trigger

Expand Messages
  • John Warner
    Insert After Insert = endless recursive loop once started, you use an insert to fire the trigger, the trigger then inserts which fires the trigger which
    Message 1 of 5 , Dec 30, 2005
    • 0 Attachment
      Message
      Insert After Insert = endless recursive loop once started, you use an insert to fire the trigger, the trigger then inserts which fires the trigger which inserts which fires the trigger...
       
       
      John Warner
      -----Original Message-----
      From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Milan Jaiswal
      Sent: Friday, December 30, 2005 1:54 AM
      To: SQLQueriesNoCode@yahoogroups.com
      Subject: [SQLQueriesNoCode] Trigger

      Hi all
      I have a trigger booking_trg on insert on booking table as follows...
       
      select
      * from booking
       
      ACC_ID    AMOUNT
      1             10
      2             20
      3             30
      4            40
      5            50
       
       
      create
      or replace trigger booking_trg
      after insert on booking
      begin
      insert into booking values (
      6,60);
      end;
      /
       
      On execution it is showing the following error
       
      ORA-00036: maximum number of recursive SQL levels (50) exceeded
       
      I understand the error but unable to explain , is it related with Mutating ?
       
      In waiting
      Monu
       
       



      Yahoo! for Good - Make a difference this year.

    Your message has been successfully submitted and would be delivered to recipients shortly.