Problem about DBMS_SESSION.SET_ROLE
I encounter the following problem:-
<< Scenario 1 >>
====================================================
SQL> begin
2 dbms_session.set_role('all');
3 end;
4 /
PL/SQL procedure successfully completed.
=======================
<< Scenario 2 >>
=====================================================
SQL> create or replace procedure define_role
2 is
3 begin
4 dbms_session.set_role('test1');
5 end;
6 /
Procedure created.
SQL> execute define_role;
BEGIN define_role; END;
*
ERROR at line 1:
ORA-06565: cannot execute SET ROLE from within stored procedure
ORA-06512: at "SYS.DBMS_SESSION", line 80
ORA-06512: at "MMON.DEFINE_ROLE", line 4
ORA-06512: at line 1
====================================================
How can I execute that package in stored procedure?
Best Regards,
Miranda