ORA-06565: cannot execute SET ROLE from within stored procedure
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.