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.
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! |