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



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 - 64bi

PL/SQL Release - Production

"CORE Production"

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

NLSRTL Version - Production


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