Hi,
One of our user just reported an ORA-30999 and google and metalink searches did not bring any help.
insert into os_archive_order (cOrder_ID, cOrder_Type, nBranch, bIndexed, dArchived,
dProcessed, cOrder_Content, cXmlVersion)
VALUES ( ?, ?, ?, 0, sysdate, null, SYS.XMLTYPE.CreateXML(?), ?)
and the xml look like this
<?xml version="1.0" encoding="ISO-8859-1"?>
<Object id ='1.7777.999999' xmlns:arc='http://otms.ch/archiving/vers/2002/09/01' >
...
</Object>
The error is returned from the application (jdbc I suppose) and is not reproducible within sqlplus.
How would you proceed to help the user?
Cheers
Laurent
Edited by: Laurent Schneider on Oct 18, 2011 12:50 PM
it used to work fine in 10g (at least it has never been reported) and now we just migrated to 11.2.0.2/AIX