Can I write execute a package as an anonymous block?
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.
set PLSCOPE_SETTINGS='identifiers:none'. Then drop the affected package and any synonym for the package and recreate.