[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: It's Urgent---Need Help--Trimming the White Space Before load ingto
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@o...] 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@i...> To: "'XML'" <xml-dev@l...> 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@i...] | 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@l... | | | ------------------------------------------------------------------ | 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@l... |
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|