PLS-00565: %s must be completed as a potential REF target
(object type)



PLS-00565: %s must be completed as a potential REF target (object type)..

Answer / guest

Cause: Incomplete library units that are potential targets
of REF dependencies must be completed so that they continue
to remain potential targets of REF dependencies (since there
might be library units with REF dependencies on this library
unit). Potential REF targets include complete and incomplete
object types. This error happened because an attempt was
made to complete a potential REF target as something other
than a potential REF target.

Action: Use another name for this library unit, or drop the
original incomplete library unit.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-33267: (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it

1 Answers  


SQL*Loader-00955: Error calling col array build, block formatter

1 Answers  


SQL*Loader-00271: Not a Parallel load. Table level OPTIONS statement ignored.

1 Answers  


ORA-14156: invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause

1 Answers  


ORA-02479: error while translating file name for parallel load

1 Answers  






ORA-24356: internal error while converting from to COBOL display type.

1 Answers  


ORA-29665: Java thread deadlock detected

1 Answers  


PCC-00090: Precision/scale specification must be given for DECIMAL datatype

1 Answers  


PLS-00330: invalid use of type name or subtype name

1 Answers  


ORA-24803: illegal parameter value in lob read function

1 Answers  


DRG-50904: weight string outside valid range 0.1 to 10.0

1 Answers  


NNC-00414: invalid name-value binding string "string"

1 Answers  


Categories