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-29390: some resource plans are not part of any top-plan

1 Answers  


DRG-11305: create/alter index string is in progress in another session

1 Answers  


ORA-13159: Oracle table string already exists

1 Answers  


ORA-14551: cannot perform a DML operation inside a query

1 Answers  


ORA-29322: SCN string size too long -- maximum size 58 bytes/characters

1 Answers  


ORA-02315: incorrect number of arguments for default constructor

1 Answers  


RMAN-11003: failure during parse/execution of SQL statement: string

1 Answers  


ORA-12646: Invalid value specified for boolean parameter

1 Answers  


TNS-00075: NOTE: the user may get the status info of a remote

1 Answers  


ORA-30131: number of keys being set exceeds allocation

1 Answers  


ORA-22911: duplicate storage specification for the nested table item

1 Answers  


RMAN-06086: offline files may only be skipped in a datafile backup set

1 Answers  


Categories