Name

composite — create a composite object

Synopsis

composite obj composite ( in x any ,
  ... );
 

Description

Create a composite object

Returns a composite object containing the serialization of each argument. The total serialized length of the arguments may not exceed 255.

Parameters

x ...

The function takes a variable number of parameters of any type.

Return Values

A composite object

Errors

Table 24.13. Errors signalled by composite

SQLState Error Code Error Text Description
22026 FT001 Length limit of composite exceeded. The sum of length of the components exceeds 255.

Examples

Example 24.45. Simple example

Get second component of a composite of two integers. See reference page for composite_ref .

SQL> select composite_ref (composite (10,20), 1);
callret
VARCHAR
_______________________________________________________________________________

20

1 Rows. -- 6 msec.


See Also

composite_ref . The chapter Composite Data Type for a definition of properties of composite objects.