RE: It's Urgent---Need Help--Trimming the White Space Before load ingto the Database

["Saxena, Saurabh" <saurabh.saxena@intel.com>]

Hi Steve
Thanks for the reply but it seems that this Discussion Forum is not working
at all.
Do u have any idea for such other Forums
regards
Saurabh


-----Original Message-----
From: Steve Muench [mailto:Steve.Muench@oracle.com]
Sent: Wednesday, May 16, 2001 8:14 PM
To: Saxena, Saurabh; 'XML'
Subject: Re: It's Urgent---Need Help--Trimming the White Space Before
loading to the Database


Hi,

Oracle-specific questions are best posted to the XML Technical
Discussion forum on our Technet website

http://otn.oracle.com/tech/xml

Then click "Discussions" at the left.

Earlier versions of the XML SQL Utility had a problem
with extra whitespace. Please state in your subsequent
posting on the Oracle XML Discussion forum whether you're
using the latest Oracle XDK for Java 9.0.0.0.0A release or not.

Thanks.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/

----- Original Message -----
From: "Saxena, Saurabh" <saurabh.saxena@intel.com>
To: "'XML'" <xml-dev@lists.xml.org>
Sent: Wednesday, May 16, 2001 7:16 AM
Subject: It's Urgent---Need Help--Trimming the White Space Before loading to
the Database


|
|
| -----Original Message-----
| From: Saxena, Saurabh [mailto:saurabh.saxena@intel.com]
| Sent: Wednesday, May 16, 2001 5:36 PM
| To: 'XML'
| Subject: Trimming the White Space Before loading to the Database
|
|
| HI
| I want to insert the XML data file in the DataBase.For that I am using a
| CLOB to stored the parsed document to it and then insert that CLOB to the
| table.This is working fine and all the values in the XML files are getting
| loaded to the database properly but the problem is coming when there is
| White Tags in some values of the XML file.(Because then the TAG size is
| exceeding the size of the column defined in the Database.Is there any
method
| by which i can trim the leading and trailing whitespaces and then load the
| values.Please help me out.it's very urgent
| I think like
| xmlgen.resetOptions,xml.setRowTag,xmlgen.setIgnoreTagCase...there should
be
| some function that can trim the white spaces from the TAG values...Please
| let me know it some reference is available on net
|
|
|
| Defining the CLOB
| -------------------------------
|  lv_main_clob   CLOB := NULL;
| Creating the Parsing Document
| ----------------------------------------------------
|  lv_parser := xmlparser.newParser;
|  lv_doc := xmlparser.getDocument(lv_parser);
|
| Writing the Parsed Document to the clob
| --------------------------------------------------------------
|  xmldom.writeToClob(lv_doc, lv_main_clob);
|
| /* -------------------------------
| Insert clob into Table
| -----------------------------------*/
|
| insert_Clob_To_Table( pi_tag_name,pi_temp_table)
| {
|
|             xmlgen.resetOptions; -- Reset options
|   xmlgen.setRowTag(pi_tag_name); -- Setting row tag
| xmlgen.setIgnoreTagCase(xmlgen.IGNORE_CASE); -- Ignore tag case
|   lv_rows_inserted := xmlgen.insertXML(pi_temp_table,lv_main_clob);
| ----->GETTING ERROR HERE
|
| }
|
|
| regards
| Saurabh
|
|
|
| ------------------------------------------------------------------
| The xml-dev list is sponsored by XML.org, an initiative of OASIS
| <http://www.oasis-open.org>
|
| The list archives are at http://lists.xml.org/archives/xml-dev/
|
| To unsubscribe from this elist send a message with the single word
| "unsubscribe" in the body to: xml-dev-request@lists.xml.org
|
|
| ------------------------------------------------------------------
| The xml-dev list is sponsored by XML.org, an initiative of OASIS
| <http://www.oasis-open.org>
|
| The list archives are at http://lists.xml.org/archives/xml-dev/
|
| To unsubscribe from this elist send a message with the single word
| "unsubscribe" in the body to: xml-dev-request@lists.xml.org
|