The COMMA_TO_TABLE stored procedure converts a list of names delimited by commas (,) into a PL table of names.
Syntax
DBMS_UTILITY.COMMA_TO_TABLE(
LIST IN VARCHAR2,
ARRAY_TYPE IN BINARY_INTEGER,
TABLEN OUT BINARY_INTEGER,
TAB_U OUT UNCL_ARRAY,
TAB_A OUT LNAME_ARRAY );
Parameters
| Parameter | Description |
|---|---|
| list | A list of names delimited by commas (,). The names must be in the a [. b]* format when they are reloaded for the first time. In the format, a and b are simple identifiers (quoted or unquoted). |
| tablen | The number of tables in the PL table. |
| tab | The PL table that contains a list of names. |
Return values
A PL table is returned. Values of the PL table are 1..n, and n+1 is NULL.
Usage notes
The list must be a non-empty list of names delimited by commas (,). Commas (,) in double quotation marks ('' '') are not counted.
Entries in the list of names delimited by commas (,) cannot contain multibyte characters.
Values of
tabare copied from the original list without any conversion.The stored procedure fails if a string between delimiters contains more than 30 bytes.