Friday, January 17, 2014
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.
cl IN CLOB,
flocation IN VARCHAR2,
fname IN VARCHAR2,
CSID IN NUMBER:=0);
SET SERVEROUTPUT ON:
-- 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';
DBMS_OUTPUT.put_line ('Error :' || SQLERRM);
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.