My Oracle Support Banner

SQL/Describe: Describing Object Attributes via a REF (Doc ID 73382.1)

Last updated on JULY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]
Oracle Database - Personal Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]
Oracle Database - Standard Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
***Checked on 27-Jun-2013***

Goal

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.


Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.