Sudhanshu
December 21st, 2003, 01:55 AM
Hi! Experts,
I am facing a problem while inserting data in XMLType Column in Oracle Database, through OCI.I am trying to insert data using temporary CLOB but it is giving me the following error:
FAILED: OCIStmtExecute() insstmt
status = OCI_ERROR
ERROR CODE = 24805
ORA-24805: LOB type mismatch
ORA-06512: at "SYS.xmlTYPE", line 0
ORA-06512: at line 1
I know that this should not be the problem as after inserting data into that column through SQLPlus I am able to read it as CLOB type which shows that there is no mismatch.
Please help me.
Thanks in advance,
Sudhanshu
I am facing a problem while inserting data in XMLType Column in Oracle Database, through OCI.I am trying to insert data using temporary CLOB but it is giving me the following error:
FAILED: OCIStmtExecute() insstmt
status = OCI_ERROR
ERROR CODE = 24805
ORA-24805: LOB type mismatch
ORA-06512: at "SYS.xmlTYPE", line 0
ORA-06512: at line 1
I know that this should not be the problem as after inserting data into that column through SQLPlus I am able to read it as CLOB type which shows that there is no mismatch.
Please help me.
Thanks in advance,
Sudhanshu