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
srmunnangi
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.2.0.4.0 on IBM/AIX RISC System/6000

Code
--------
create or replace package body test_xml1 (p_xml_in in xmltype,p_xml_out out xmltype)
begin
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
..
else
..
end if;
end;


Can anybody give suggestion to proceed further. Thanks in Advance

Munnangi
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: Fri Mar 29 03:13:38 CDT 2024