[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] It's Urgent---Need Help--Trimming the White Space Before loading tothe D
-----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...
|
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
|