Data from one database not transferred to another database (using DB LINK) if user is not OBJECT OWNER
Posted on 2006-11-15
I am using Oracle Forms in my application. Users for the application are setup to be either an 'OBJECT OWNER' or an 'APPLICATION USER'.
I have a screen that calls a package to transfer data from the current database to another database, using a PUBLIC DATABASE LINK.
Unfortunately when the user that processed the data transfer is NOT THE OBJECT OWNER (i.e. just an APPLICATION USER), I get the error: "ORA-02070: database does not support in this
context". I think it may be because my table has a default of SYS_CONTEXT('APP','BRANCH') in one of its fields. Unfortunately, I need this default for the forms processing.
I have also tried using the OBJECT OWNER to do the processing and it is working fine. Unfortunately, there may be cases when the user to do the processing is not the object owner, so I need to have this problem fixed.
Please help. This is kinda urgent.