Loading...

Thursday, July 23, 2015

About using APEX_COLLECTIONS in a tabular form with INSTEAD OF triggers

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
 
In case you dreamed of updating an Apex tabular form built on top of a view based on APEX_COLLECTIONS by means of INSTEAD OF triggers, you must be ready to grant the following rights to the schema user attached to the workspace, otherwise you'll get an ORA-01031: Insufficient privileges run-time error.
Each privilege is only required for the corresponding action, if you don't need to delete from the view you can safely omit GRANT DELETE for instance.
 
GRANT UPDATE,INSERT,DELETE ON APEX_xxxxxx.APEX_COLLECTIONS TO user_schema;

This DDL can only be executed by the DBA or by the APEX_xxxxxx user.
Probably the DBA won't like to do it for the usual security issues.

Note also that this kind of permissions are not carried over during subsequent Apex upgrades, which means that tabular forms will stop working if you forget to re-execute the grants after a major upgrade.


See message translations for ORA-01031 and search additional resources.

Tuesday, June 09, 2015

In case you wish to download Apex 5.0 documentation as a zip file

For some reason the official page for Oracle Application Express release 5.0 doesn't include a download link for its documentation library, while archived releases are all available for download from the following page:

http://www.oracle.com/technetwork/developer-tools/apex/documentation/apex-094287.html

Fortunately for us the consistency in Oracle's internal documentation library organization provides us with the following valid link for downloading the whole document set for Apex 5.0.

http://download.oracle.com/docs/cds/E59726_01.zip


yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles