Oracle 12c R2 problem opening PL/SQL Web procedure
I installed Oracle 12 R2 on windows 10 machine. I am not able to view a PL/SQL procedure Web page in browser.
I created a DAD with dynamic authentication as follows (where corclpdb is the pluggable database, and cis528inst2 is the username where I have a sample Web procedure page).
SQL> alter session set container=corclpdb;
Session altered.
SQL> EXEC DBMS_EPG.CREATE_DAD('ora12psp', '/ora12psp/*');
PL/SQL procedure successfully completed.
SQL> exec dbms_epg.set_dad_attribute('ora12psp','database-username','ANONYMOUS');
PL/SQL procedure successfully completed.
SQL> exec dbms_epg.authorize_dad('ora12psp','ANONYMOUS');