PLS-00252: reference to the wrong copy of package STANDARD



PLS-00252: reference to the wrong copy of package STANDARD..

Answer / guest

Cause: A reference is made to the fixed package version of
STANDARD when the database is open, or to the on-disk
version when the database is closed. Explicit use of a
SYS.X$ package name can lead to this. One might also see
this from a compilation that begins while the db is closed
but has the bad luck to have another session open the db
before compilation is complete. Another possible cause is
having 'set serveroutput on' through svrmgrl when doing an
'alter database close'.

Action: Make use of on-disk versions of packages when the
database is open and fixed (preloaded) versions when the
database is closed. Do not attempt to use the wrong set. It
should be quite hard to reference the wrong set, except by
using SYS.X$ package names explicitly. Also, be sure to 'set
serveroutput off' before doing an 'alter database close'.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12732: invalid interval value in regular expression

1 Answers  


ORA-15013: diskgroup "string" is already mounted

1 Answers  


ORA-00000: normal, successful completion

1 Answers  


ORA-19590: conversation already active

1 Answers  


QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)

1 Answers  


ORA-22828: input pattern or replacement parameters exceed 32K size limit

1 Answers  


ORA-01653: unable to extend table string.string by string in tablespace string

1 Answers  


ORA-01027: bind variables not allowed for data definition operations

1 Answers  


ORA-27203: skgfpqb: sbtpcquerybackup returned error

1 Answers  


ORA-02785: Invalid shared memory buffer size

1 Answers  


ORA-01595: error freeing extent (string) of rollback segment (string))

1 Answers  


ORA-15042: ASM disk "string" is missing

1 Answers  


Categories