The PUTF_NCHAR stored procedure writes NCHAR text to a file according to a format string.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
UTL_FILE.PUTF_NCHAR (
file IN FILE_TYPE,
format IN NVARCHAR2,
arg1 IN NVARCHAR2 DEFAULT NULL,
arg2 IN NVARCHAR2 DEFAULT NULL,
arg3 IN NVARCHAR2 DEFAULT NULL,
arg4 IN NVARCHAR2 DEFAULT NULL,
arg5 IN NVARCHAR2 DEFAULT NULL)
Parameters
Parameter |
Explanation |
|---|---|
| file | byFOPEN_NCHARThe file handle opened in text write mode. |
| format | NCHAR format string.%sIn order:arg1toarg5Replace,\nRepresents the line terminator. |
| arg1 to arg5 | Used to replace the format string's%sThe optional NCHAR parameters, with a maximum of five. The default value for all isNULL. |
Usage instructions
If format is NULL, no content is written. Using a file handle returned by the regular FOPEN function will trigger a CHARSETMISMATCH exception.