Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-29532: oracle.xml.sql.OracleXMLSQLException: ORA-01403: no data found

425787Apr 7 2005 — edited Apr 12 2005
Hello there,

I am getting "ORA-29532: Java call terminated by uncaught Java exception: oracle.xml.sql.OracleXMLSQLException: ORA-01403: no data found
ORA-06512: at line 1" Error. Here is the complete environment information:

o Oracle9i EE Release 9.2.0.6.0 - 64bit Production
o INPUT Schema contains:
. OBJECT TYPEs
. O-R table using these OBJECT TYPEs (nested tables)
. "ALL" privilege has been granted on these TYPEs
. and ORTable and PUBLIC SYNONYMs have also been
. defined on these TYPEs and ORTable.
o MAIN Schema contains:
. XMLSchema is registered
. PL/SQL Code to receive XML doc in XMLType variable
. PL/SQL Code validates XML using XMLType.schemaValidate
. PL/SQL Code uses DBMS_XMLSave.insertXML to insert
. XML data into INPUT.ORTable but fails with above
. mentioned error:

For some reasons, I have to keep the target ORTable in a separate schema and register the XML Schema in a diferent DB Schema along with PL/SQL Code.

TIA

Amer

Any suggestions guidelines are highly appreciated.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 10 2005
Added on Apr 7 2005
#performance-availability, #xml-db
4 comments
868 views