Skip to Main Content
Forums

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!

What are opaque types (OPAQUE VARYING)?

925144May 11 2012 — edited May 14 2012
A number of oracle types like XMLType, Anydata and lcr$_row_record are defined in SYS through "AS OPAQUE VARYING (*)
USING LIBRARY".

I wonder what is this? The only thing in documentation I've found is "Oracle OPAQUE Types" from SQLJ Developer's Guide. (http://docs.oracle.com/cd/E11882_01/java.112/e10590/objcoll.htm#i1008113)

But I couldn't grasp how is it related to PL/SQL. How do I make my own opaque type?

What are the benefits of opaque types compared to normal PL/SQL object types?
This post has been answered by unknown-7404 on May 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2012
Added on May 11 2012
6 comments
2,047 views