Name
composite_ref — get member of a composite object
Synopsis
integer
composite_ref
(
|
in c any , |
in
nth
integer
); |
Description
composite_ref returns the nth
element of the composite. The index is 0 based.
Parameters
nth
integer
Return types
The type returned is the type of the composite member referred to.
Errors
Table 24.12. Errors signalled by composite_ref
| Error Type | Error Code | Error Text | |
|---|---|---|---|
| 22023 | FT002 | composite expected for composite ref | |
| 22003 | FT003 | composite index out of range %d for length %d |
Examples
Example 24.47. Simple example
Get first member of a composite consisting of VARCHAR values.
SQL> select composite_ref (composite ('Miles','Herbie','Wayne','Ron','Tony'), 0);
callret
VARCHAR
_______________________________________________________________________________
Miles
1 Rows. -- 4 msec.
See Also
The Composite Data Type for a definition of the properties of composite objects.
The function
composite.