This discussion is archived
5 Replies Latest reply: Jul 31, 2013 9:17 AM by Hoek RSS

Not able to create trigger.

947771 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points