Last updated
Last updated
This procedure closes an open file identified by a file handle. ()
This procedure is implemented using Snowflake to store the written text files.
The UTL_FILE
schema must be created.
If you want to download the file, run the following command.
The command runs in .
This procedure writes to the utlfile_local_directory stage all lines with the same FHANDLE
from the file in FOPEN_TABLES_LINES
.
Oracle
The user can modify the procedure if it is necessary to change the name of the stage.
The location used to write to this procedure is static. A new version of the procedure is expected to increase its extensibility by using the location that has the FILE
parameter.
This procedure for now, only writes .CSV files.
No issues were found.
FILE: Active file handler returned from the call to
This procedure uses the FOPEN_TABLES_LINES
table created in the procedure.
These procedures are implemented for the internal stages in the
To run this example, see
: Data Type Not Recognized.
: Unnecessary built-in packages parameters.
Translation reference for UTL_FILE.FCLOSE.