OraFAQ Forum: SQL & PL/SQL » how to write in appned mode thru DBMS

Home » SQL & PL/SQL » SQL & PL/SQL » how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE [message #353218]

Sun, 12 October 2008 23:37

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

Report message to a moderator

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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 ?

Report message to a moderator

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to write your own program.

Regards
Michel

Report message to a moderator

Previous Topic:	How to Identify Table Usage Information
Next Topic:	Mysterious where clause with japanese

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 20:56:59 CST 2025