Package lob_writer_plsql
Note that the package LOB_WRITER_PLSQL is deprecated. It will stay within this package "as-is", but there will be no further development on it.
The package LOB_WRITER_PLSQL is a helper package for writing LOB content (BLOB, CLOB) to a file. This could also be achieved using the FILE_TYPE object type or the OS_COMMAND package but this package deals with pure PL/SQL without utilizing java in the database.
Use this package if you don't want to grant special java privileges and you want to use "traditional" Oracle directory objects and the UTL_FILE package.
| Method Summary |
| write_blob(p_directory varchar2, p_filename varchar2, p_data blob)
writes a BLOB to a file
|
| write_clob(p_directory varchar2, p_filename varchar2, p_data clob)
writes a CLOB to a file
|
write_clob
public write_clob(p_directory varchar2,
p_filename varchar2,
p_data clob)
- writes a CLOB to a file
-
- Parameters:
-
p_directory -
Name of the Oracle Directory object (see dictionary view ALL_DIRECTORIES)
-
p_filename -
Name of the file to be written
-
p_data -
CLOB content to be written
write_blob
public write_blob(p_directory varchar2,
p_filename varchar2,
p_data blob)
- writes a BLOB to a file
-
- Parameters:
-
p_directory -
Name of the Oracle Directory object (see dictionary view ALL_DIRECTORIES)
-
p_filename -
Name of the file to be written
-
p_data -
BLOB content to be written