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!

ORA-20876 when calling APEX_SESSION.CREATE_SESSION

Flavio CNov 18 2021

Hi,
Apex 18.2.0.00.12
I am getting "ORA-20876: Stop APEX Engine"
when executing the following block in SQLDeveloper:
begin
apex_util.set_security_group_id(APEX_UTIL.FIND_SECURITY_GROUP_ID('PO'));
apex_session.create_session(109, 1, 'PROCUREMENT');
end;

I am executing this code as one of the oracle users (schema) linked to the workspace 'PO'.
The workspace is associated to three different schemas and the one I am using is not the primary schema (and I cannot log into that schema for reasons too long to be explained here).
If the problem is caused by the fact that the API can only be executed by the primary schema, then I would suggest to make it clear in the documentation because there is nothing explained there.
If there is some other reason that I am overlooking, please advise.
Thank you
Flavio

Comments
Post Details
Added on Nov 18 2021
0 comments
349 views