Home » Developer & Programmer » JDeveloper, Java & XML » XML Data Extarct in oracle 9i
XML Data Extarct in oracle 9i [message #259166] Tue, 14 August 2007 09:52
Messages: 7
Registered: March 2005
Junior Member

Hi All,

We are experiencing a problem in related to XML Data extraction. We are using extract method to extract the data from XML file to table.

This XML file contains Two fields. One is node value(FRONT_IMAGE) and other one is node length (FRONT_IMAGE_LENGTH). During Extraction process, I am comparing supplied length to caliculated length. If calculated length is more than 64k, the process is erroring out with custom messages.

We are using Oracle9. on IBM/AIX RISC System/6000

create or replace package body test_xml1 (p_xml_in in xmltype,p_xml_out out xmltype)
v_front_image := p_xml_in.EXTRACT ('/mes:TRANSACTION/FRONT_IMAGE/text()').getClobval();
v_fi_length := LENGTH(v_front_image);

v_xml_fi_length := p_xml_in.EXTRACT('/mes:TRANSACTION/LENGTH_OF_FRONT_IMAGE/text()').getStringVal();

if v_fi_length = v_xml_fi_length then
end if;

Can anybody give suggestion to proceed further. Thanks in Advance

Previous Topic: How to Open JSP file as Ms Excel
Next Topic: How to create xml from database using standard xmlsheema
Goto Forum:

Current Time: Sat May 25 11:56:48 CDT 2024