Home > Default > Error while inserting XMLType document into table

Error while inserting XMLType document into table

November 30Hits:0
Advertisement
Dear sir,
I have created a table in oracle 9i.The description is as follows:
Name Null? Type
ID NUMBER
XML_DOCUMENT SYS.XMLTYPE(XMLSchema "http:
//localhost:8080/home/SCOTT/
xsd/message.xsd" Element "me
ssage") STORAGE Object-relat
ional TYPE "MESSAGE_TYPE"
Later I tried to insert values into this table using the following statement:
1 insert into test1(ID,XML_DOCUMENT)
2 VALUES
3 (100,
4 xmltype
5 (
6 bfilename('xmldir','message1.xml'),
7 nls_charset_id('AL32UTF8')
8 )
9* )
I get the following error:
ERROR at line 4:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'.
I have no idea of what to do now.Can someone please tell me how to proceed.
Reference:(this is for the insert command statement)
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10790/xdb04cre.htm#BABDCAFB
Thanking you in advance,
Sincerely,
Sirisha.

Answers

Yes, but bear in mind that Text searching is not truely XML aware...
Also, a single 65M document is probably not a single docuemnt, it's probably a collection of smaller documents that have been colllected together into a single document. It may make more sense to split this into it's seperate components before loading it into the database...
The typcical signature of document of this nature is
<ROOT>
<ELEMENT>
</ELEMENT>
<ELEMENT>
</ELEMENT>
<ELEMENT>
</ELEMENT>
</ROOT>

Read other 9 answers

Tags:

Related Articles

  • Error while inserting XMLType document into tableNovember 30

    Dear sir, I have created a table in oracle 9i.The description is as follows: Name Null? Type ID NUMBER XML_DOCUMENT SYS.XMLTYPE(XMLSchema "http: //localhost:8080/home/SCOTT/ xsd/message.xsd" Element "me ssage") STORAGE Object-relat ion

  • Getting error while inserting xmldoc to a tableOctober 11

    I am getting following error . ERROR at line 2: ORA-06550: line 2, column 6: PLS-00103: Encountered the symbol "INSERTXML" when expecting one of the following: := . ( @ % ; The symbol ":=" was substituted for "INSERTXML" to c

  • Error in inserting XML documentNovember 30

    I'm trying to insert into a table from an HTML form. Here's the table I'm trying to insert into TABLE employee name VARCHAR2(40), ssnum NUMBER NOT NULL Note: even though SSNUM is number I take it as a string and I have a before insert trigger that co

  • Error while Inserting data into flow tableOctober 11

    Hi All, I am very new to ODI, I am facing lot of problem in my 1st interface. So I have many questions here, please forgive me if it has irritated to you. ======================== I am developing a simple Project to load a data from an input source f

  • Error while saving xml document in tableOctober 11

    I am using dbms_xmlsave.insert to insert records in the table. The procedure works fine when the xml file size is less then 1 Mb. But when the file size is around 4 MB I get the error java.lang.outofMemoryError. Is there any limitation of number of r

  • Error while inserting rows in a tableOctober 11

    Hi, We have recently migrated from 9i to 10g. We have a scheduled job out our DB which first deletes all the rows from a table and then inserts them back by selecting rows from 5 tables. This table has a composite primary key based on 6 columns in it

  • Error while inserting data into a table.October 11

    Hi All,   I created a table.While inserting data into the table i am getting an error.Its telling "Create data Processing Function Module".Can any one help me regarding this? Thanx in advance anirudhHi Anirudh,   Seems there is already an entry

  • Getting Error While inserting a record in table PDSNR through Tcode PA30October 11

    Hi Experts, Im doing a transaction in  TCode PA30 by entering a pernr and infty as 14 and wage type. My need is when im entering a particular wage type in PA30 with infotype 14 , for that particular wage type and infotype i need to assign a different

  • [CS2-JS] Error when inserting some text in table cell via XMLElementNovember 30

    I have a very very strange InDesign behaviour when using XMLElement in a table Cell to insert a string. For example (in a table that has an XML structure) : var cell = table.cells[0]; var cell_xe = cell.associatedXMLElement; var newtag_xe = cell_xe.x

  • Error when inserting into a internal tableOctober 11

    hello. I get the fowolling error. An exception occurred that is explained in detail below. The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught   and therefore caused a runtime error. The reason for the exception is: In a SEL

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.663 s.