Database Security Products (MOSC)

MOSC Banner

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

edited Jul 27, 2019 5:09AM in Database Security Products (MOSC) 9 commentsAnswered

Hello experts,

i have a package with proceduce which can be run completed sucessfully in 11.2.0.4 env.

but in the new 18c env I have call a procedure inside the package as below command:

begin

CAMDEV.ACS_PKG.GRANT_APP_ROLE();

end;
/

but return error as :

Error report -

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

ORA-06512: at "CAMDEV.ACS_PKG", line 27

ORA-06512: at line 4

06565. 00000 -  "cannot execute %s from within stored procedure"

*Cause:    The named procedure cannot be executed from within a stored

           procedure, function or package.  This function can only be

           used from pl/sql anonymous blocks.

*Action:   Remove the procedure from the calling stored procedure.

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