Friday, January 17, 2014
DBMS_XSLPROCESSOR.CLOB2FILE Example Script to Write a CLOB data to file
In our current project, we have a requirement for writing a data
stored in CLOB column to a file. We found a standard ORACLE API DBMS_XSLPROCESSOR.CLOB2FILE
In this post, we have tried to
explain the same API with an example. We hope it helps.
API Specification:
DBMS_XSLPROCESSOR.CLOB2FILE(
cl IN CLOB,
flocation IN VARCHAR2,
fname IN VARCHAR2,
CSID IN NUMBER:=0);
Script:
SET SERVEROUTPUT ON:
DECLARE
-- CLOB data
lv_clob CLOB DEFAULT 'This is a example
testing by SHAREORACLEAPPS';
-- Database directory for a physical location
lv_utl_file_directory VARCHAR2 (100) DEFAULT 'TEST_DB_DIRECTORY';
-- Output Filename
lv_file_name VARCHAR2 (100) DEFAULT 'TESTFILE.txt';
BEGIN
DBMS_XSLPROCESSOR.clob2file (lv_clob,
lv_utl_file_directory,
lv_file_name
);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error :' || SQLERRM);
END;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
3 Responses to “DBMS_XSLPROCESSOR.CLOB2FILE Example Script to Write a CLOB data to file”
March 13, 2014 at 10:01 PM
August 17, 2014 at 11:27 PM
May 13, 2020 at 3:56 AM
Good material for quick reference
Post a Comment