SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Erhan_torontoSep 4 2013 — edited Sep 4 2013

11gR2

---------------

Why I am getting below error? I search google but I didn't understand the reason. can you please explained in more clearly. Thanks

CREATE OR REPLACE TYPE "A" as object (

x_ number,

y_ varchar2(10),

member procedure to_lower

);

ORA-06545: PL/SQL: compilation error - compilation aborted

ORA-06550: line 7, column 1:

PLS-00103: Encountered the symbol "CREATE"

ORA-06550: line 0, column 0:

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

This post has been answered by Paul Horth on Sep 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2013

Added on Sep 4 2013

#performance, #report, #sqlplus, #update

10 comments

9,920 views