PLS-00372: In a procedure, RETURN statement cannot contain
an expression
Answer / guest
Cause: 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.
Action: Remove the expression from the RETURN statement, or
redefine the procedure as a function.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 1 No |
ORA-24276: function 'string' output 'string' maximum value exceeded
PLS-00222: no function with name 'string' exists in this scope
ORA-07508: scgfal: $deq all unexpected return
ORA-32801: invalid value string for string
EXP-00082: Invalid function name passed to procedural object support: string
ORA-13199: %s
ORA-23293: Cannot rename a column which is part of a join index
ORA-02845: Invalid value for the timing wanted flag
RMAN-06075: datafile string does not belong to this database
NNL-00956: Hash tables freed: number
ORA-24908: invalid recipient presentation attribute
DRG-12607: only ctxsys can create MULTI_COLUMN preferences