This discussion is archived
3 Replies Latest reply: Nov 11, 2013 9:52 PM by Rajanjai RSS

Create a xml file of SOAP RESPONSE in oracle directory

Rajanjai Newbie
Currently Being Moderated

Hi,

 

I'm working web services, I receive a response file that contain 72000 characters in one node but maximum size of a node is 64K that can be inserted into table . So Im trying to create it as file but my file contains only 32765 characters .Please give me a solution.

 

   

code used

*************

  DBMS_XSLPROCESSOR.clob2file(cl => SOAP_RESPONSE , flocation => 'MY_DIR', FNAME => 'SAMPLEXML.XML');

 

Database Details

*******************

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

"CORE 10.2.0.4.0 Production"

TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio

NLSRTL Version 10.2.0.4.0 - Production

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points