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!

PL/SQL block fails to run in APEX

Dave_VZApr 5 2023 — edited Apr 6 2023

Oracle 19c on Amazon RDS: I have a block of code that executes in SQLPLUS but fails in APEX. I suspect my APEX privileges are a mess – it's an inherited problem on which I'm stuck and need guidance.

Possibly related: in the SQL Workspace, as a DBA, I cannot query the SYS.DBA* views. TIA.

green_sample_ok_out.pdf

green_sample_apex_admin_fail.pdf

green_sample_apex_sys_fail.pdf

Comments
Post Details
Added on Apr 5 2023
5 comments
552 views