Home > Default > Error while inserting XMLType document into table

Error while inserting XMLType document into table

November 30Hits:0
Dear sir,
I have created a table in oracle 9i.The description is as follows:
Name Null? Type
xsd/message.xsd" Element "me
ssage") STORAGE Object-relat
Later I tried to insert values into this table using the following statement:
1 insert into test1(ID,XML_DOCUMENT)
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)
Thanking you in advance,


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

Read other 9 answers


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.