| Inserting XMLType through OCI [message #94067] |
Sat, 20 December 2003 04:54 |
sudhanshu
Messages: 5
Registered: April 2002
|
Junior Member |
|
|
I am trying to insert data in XMLType through OCI by creating a Temporary CLOB and then writing the data into that CLOB.I bound the parameter as SQLT_CLOB.But in execute it is giving me the following error:
=> Inserting to row 1......
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
My Query is INSERT INTO CDEMOXML_FOO (xml_col, int_col) VALUES (sys.xmltype.createxml(:xmlval), :intval)"
But if I insert it throught SQL using createXML and then try to read that data using getClob, I am getting the correct value which shows that The Lob type is of Clob.
I have even tried the test program provided By Oracle 'cdemoxml.c'but it is giving the same error
Any help is highly appreciated
Thanks in advance
Sudhanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
