Home » SQL & PL/SQL » SQL & PL/SQL » how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE (Oracle 10g)
how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE [message #353218] Sun, 12 October 2008 23:37 Go to next message
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
Member
Hi,
Is it possible to write the content of a clob variable to the ascii file in append mode ?
DBMS_XSLPROCESSOR.CLOB2FILE deletes the old record, inserts new data. Since my data is more than 4GB , I want to write in same ascii file by part .

Thanks
Re: how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE [message #353226 is a reply to message #353218] Mon, 13 October 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, UTL_FILE allow to open a file in append mode.
Nevertheless this interface only allow VARCHAR2 datatype, limited to 32K, so you will to split your clob in many chunks.

Regards
Michel
Re: how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE [message #353300 is a reply to message #353218] Mon, 13 October 2008 05:06 Go to previous messageGo to next message
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
Member
I don't want to use utl_file due to performance issue. I want to capture all data in a clob variable and write to OS ascii file in single shot. But in case the data is more than 4 GB, I will split and assign it to number of clob variables and write to a file from all these variables. Is it feasible ?
Re: how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE [message #353302 is a reply to message #353300] Mon, 13 October 2008 05:19 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to write your own program.

Regards
Michel
Previous Topic: How to Identify Table Usage Information
Next Topic: Mysterious where clause with japanese
Goto Forum:
  


Current Time: Wed Dec 07 04:57:08 CST 2016

Total time taken to generate the page: 0.08664 seconds