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
Table24.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
Example24.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.