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.14. Errors signalled by composite_ref

22023 FT002 composite expected for composite ref  
22003 FT003 composite index out of range %d for length %d  

Examples

Example 24.46. 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 .