The CONCAT function concatenates a maximum of 12 RAW strings into one RAW string. If the size of the concatenated RAW exceeds 32,767 bytes, an error is returned.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
UTL_RAW.CONCAT (
r1 IN RAW DEFAULT NULL,
r2 IN RAW DEFAULT NULL,
r3 IN RAW DEFAULT NULL,
r4 IN RAW DEFAULT NULL,
r5 IN RAW DEFAULT NULL,
r6 IN RAW DEFAULT NULL,
r7 IN RAW DEFAULT NULL,
r8 IN RAW DEFAULT NULL,
r9 IN RAW DEFAULT NULL,
r10 IN RAW DEFAULT NULL,
r11 IN RAW DEFAULT NULL,
r12 IN RAW DEFAULT NULL)
RETURN RAW;
Parameters
r1 to r12 are the RAW items to be concatenated.
Return values
| Return value | Description |
|---|---|
| RAW | This value contains the RAW values that are concatenated. |
Exceptions
If the total length of the input RAWs exceeds 32,767 bytes, which is the maximum length allowed for a RAW, an error is reported.