Database Administration (MOSC)

MOSC Banner

Can I write execute a package as an anonymous block?

edited Oct 1, 2013 1:58AM in Database Administration (MOSC) 8 commentsAnswered

Hi All,
We have upgraded our database from 11.1.0.7 to 11.2.0.2 version.
After upgrade we are facing below error for our pl/sql executions.

ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [],
[], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

We have followed the below support document that talks about our problem:

ORA-600 [kqlidchg1] ORA-00001: Unique Constraint (Sys.I_plscope_sig_identifier$) Violated (Doc ID 1341014.1)

But, the workaround mentioned in the document is not working with us.


The workaround was: 

set PLSCOPE_SETTINGS='identifiers:none'. Then drop the affected package and any synonym  for the package and recreate.

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