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 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]
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

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