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