5 Replies Latest reply: Jul 31, 2013 11:17 AM by Hoek RSS

    Not able to create trigger.

    947771

      hi,

      i am using 11g express r2, sql devloper 3.1.07

      ----------------

      ORA-00603: ORACLE server session terminated by fatal error

      ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []

      ORA-00604: error occurred at recursive SQL level 2

      ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

      No more data to read from socket

      No more data to read from socket

      No more data to read from socket

      --------------------

       

      I was getting above error while creating trigger dynamically from stored procedure.

       

      some body suggested me following and it is working now.

      EXECUTE IMMEDIATE 'ALTER SESSION SET PLSCOPE_SETTINGS = ''IDENTIFIERS:NONE''';

      EXECUTE IMMEDIATE 'ALTER SESSION SET PLSCOPE_SETTINGS = ''IDENTIFIERS:ALL''';

       

      But personaly while testing i gave all permission to a user and it started creating trigger using stored procedure with out using above setting.

       

      1) please tel me which permission is used for above?

      2) I have read  PLSCOPE_SETTINGS but could not under stand much please explain or provide any link where it is explianed.

      3) is there any disadvandage of setting  PLSCOPE_SETTINGS to NONE .

       

      yours sincerely