SQL/Describe: Describing Object Attributes via a REF

(Doc ID 73382.1)

Last updated on JUNE 27, 2013

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.0.3 to 11.2]
Oracle Database - Personal Edition - Version to [Release 8.0.3 to 11.2]
Oracle Database - Standard Edition - Version to [Release 8.0.3 to 11.2]
Information in this document applies to any platform.
***Checked on 27-Jun-2013***


This article contains an example program which demonstrates how to obtain details of an object type from a REF selected from a table. You can obtain the type name from the statement handle and pass it to OCIDescribeAny to obtain details of the attributes within the type.

Thus, if the REF is used to pin the corresponding object in the cache, you can access and update the attributes of that object without knowing what their datatypes are at compile time.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms