Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-09945: Unable to initialize the audit trail file

1 Answers  


ORA-22331: cannot alter an incomplete type

1 Answers  


DRG-50861: failed to obtain type descriptor

1 Answers  


ORA-14520: Tablespace string block size [string] does not match existing object block size [string]

1 Answers  


SQL*Loader-00512: Unable to free read buffer

1 Answers  






SQL*Loader-00456: end of collection found after number elements when looking for number elements

1 Answers  


NNO-00059: cannot construct topology checkpoint file name

1 Answers  


PCC-00080: TYPE identifier already TYPEd

1 Answers  


SQL*Loader-00812: error creating internal table: string

1 Answers  


ORA-00399: corrupt change description in redo log

1 Answers  


DRG-10304: unexpected error sending command(s) to Oracle Text server

1 Answers  


ORA-24122: invalid block range specification

1 Answers  






Categories