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!

ORA-01031: insufficient privileges updating xml contents in resource_view

312365Oct 19 2005 — edited Nov 18 2005

All,

Any got any ideas on how to trace the cause of the following exception:
java.sql.SQLException: ORA-01031: insufficient privileges
ORA-06512: at "XDB.XDB_RVTRIG_PKG", line 21
ORA-06512: at "XDB.XDB_RV_TRIG", line 15
ORA-04088: error during execution of trigger 'XDB.XDB_RV_TRIG'

when attempting to update an xml document (through JDBC) using the following prepared statement:

update resource_view 
set res = updateXml(res, '/Resource/Contents/*', ?)
where equals_path(res, ?) = 1

To complicate matters we are using proxy connections but both the actual user and the proxy user can access the package XDB.XDB_RVTRIG_PKG.

I've checked but there wasn't a udump file created with any more information.

Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2005

Added on Oct 19 2005

#performance-availability, #xml-db

3 comments

1,106 views