Hi, I created an application to insert XML and read the XML back to/from Oracle DB using CLOB & Weblogic. It's working fine except for some XML that I cannot read it back and got the SQL Exception with Oracle 24334 Error : ORA-24334 no descriptor for this position Cause: The application is trying to get a descriptor from a handle for an illegal position. Action: Check the position number. For loading / saving other XML it's working really perfect. I tried to analyze the XML but it's correct and no special characters inside. ------- Ok .. after I analyze it, it seems like if the XML that I saved is too big (more than 23 Kb) then it will fail to read it back, only XML which is smaller that it can read back. The funny thing is I created App without Weblogic (directly use CLOB object not rmi.weblogic.jdbc.rmi.SerialClob) then it can read it properly. Any help ? Maybe I have to set something in Weblogic Datasource configuration ?
Three comments: 1) It would be easier to help if you posted your JDBC code. Maybe one of us will spot the problem. 2) The problem could be an issue with the JDBC Driver. Have you tried a different Driver? 3) I prefer storing large String objects in an LONG field, I find them easier to work with (as expected there are some tradeoffs).
Joined: Feb 28, 2003
Hi, Sorry for late reply, was busy... Thank you for all the good comments, finally I used LONG .. it's easier and better.