Skip to Main Content

APEX

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!

Problems with APEX_INSTANCE_ADMIN

Luca68Oct 15 2014 — edited Oct 16 2014

I am having problems calling the APEX_INSTANCE_ADMIN package from Apex 4.2.5

Before assigning (or after revoking) the APEX_ADMINISTRATOR_ROLE I get:

  • ORA-06550: line 5, column 1: PLS-00201: identifier 'APEX_INSTANCE_ADMIN' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored

(which I presume is fine), but after granting the APEX_ADMINISTRATOR_ROLE I get the following message:

User requires ADMIN privilege to perform this operation.

Contact your application administrator

Same if I use the "Database Account" authentication scheme and log on as SYS or SYSTEM.

Any suggestions? Thanks in advance.

Luca

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2014
Added on Oct 15 2014
5 comments
1,862 views