PL/SQL (MOSC)

MOSC Banner

Oracle 12c R2 problem opening PL/SQL Web procedure

edited Nov 7, 2019 1:20PM in PL/SQL (MOSC) 11 commentsAnswered

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center