SQL & PL/SQL

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!

Set Role from procedure

607971Mar 27 2008 — edited Mar 31 2008

I get this error if I try to execute SET ROLE <rolename> from
the procedure

Error::: ORA-06565: cannot execute SET ROLE from within stored procedure

May I know how to activate the role from the procedure ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2008

Added on Mar 27 2008

3 comments

587 views