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-29884: domain index is defined on the column to be dropped

1 Answers  


ORA-01415: too many distinct aggregate functions

1 Answers  


SQL*Loader-00306: Token longer than max allowable length of number chars

1 Answers  


ORA-06525: Length Mismatch for CHAR or RAW data

1 Answers  


ORA-02882: sou2o: Could not register SGA for protection

1 Answers  


NNF-04003: Entry in inputfile is too long

1 Answers  


ORA-16002: database already open for read-write access by another instance

1 Answers  


ORA-22908: reference to NULL table value

1 Answers  


LPX-00318: duplicate xsl:decimal-format "~S"

1 Answers  


DRG-11533: improper value of column string

1 Answers  


ORA-27153: wait operation failed

1 Answers  


ORA-15003: diskgroup "string" already mounted in another lock name space

1 Answers  


Categories