Cause: The caller did not have the specified role or called the procedure from a definer's rights package or procedure. See the solution below.
Error solution: Grant the specified role to the caller. If the procedure is called from a definer's rights package or procedure, change the definer's rights package or procedure to an invoker's rights package or procedure. Or grant all the privileges for the specified role explicitly.
Database version: Oracle 11g Release 2 (11.2)