Oracle Error Message
PLS-00372: In a procedure, RETURN statement cannot contain an expression
Reason for the Error
In a procedure, a RETURN statement contains an expression, which is not allowed. In functions, a RETURN statement must contain an expression because its value is assigned to the function identifier. However, in procedures, a RETURN statement simply lets you exit before the normal end of the procedure is reached.
Solution
Remove the expression from the RETURN statement, or redefine the procedure as a function.
