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


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-02060: select for update specified a join of distributed tables

1 Answers  


TNS-00232: Unable to setup connection

1 Answers  


ORA-30766: cannot modify scope for a REF column with a REFERENCES constraint

1 Answers  


ORA-24351: invalid date passed into OCI call

1 Answers  


ORA-31411: change set string is referenced by a change table

1 Answers  






ORA-00406: COMPATIBLE parameter needs to be string or greater

1 Answers  


ORA-23291: Only base table columns may be renamed

1 Answers  


ORA-01877: string is too long for internal buffer

1 Answers  


ORA-16534: no more requests accepted

1 Answers  


ORA-22992: cannot use LOB locators selected from remote tables

1 Answers  


NNL-00512: Shows or sets the server's auto-refresh expiration period

1 Answers  


ORA-27196: skgfpbk: sbtpcbackup returned error

1 Answers  






Categories