Oracle Error ORA-28261: CURRENT_USER can not be used in PLSQL Definer’s Right procedure.

Oracle Error Message

ORA-28261: CURRENT_USER can not be used in PLSQL Definer’s Right procedure.

Reason for the Error

An attempt to retrieve CURRENT_USER using SYS_CONTEXT PLSQL interface.

Solution

Use a SQL statement to query CURRENT_USER inside a DR procedure.