PLS-00372: In a procedure, RETURN statement cannot contain
an expression



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

Post New Answer

More Oracle Errors Interview Questions

ORA-24276: function 'string' output 'string' maximum value exceeded

1 Answers  


PLS-00222: no function with name 'string' exists in this scope

1 Answers   QuinStreet,


ORA-07508: scgfal: $deq all unexpected return

1 Answers  


ORA-32801: invalid value string for string

1 Answers  


EXP-00082: Invalid function name passed to procedural object support: string

1 Answers  






ORA-13199: %s

1 Answers  


ORA-23293: Cannot rename a column which is part of a join index

1 Answers  


ORA-02845: Invalid value for the timing wanted flag

1 Answers  


RMAN-06075: datafile string does not belong to this database

1 Answers  


NNL-00956: Hash tables freed: number

1 Answers  


ORA-24908: invalid recipient presentation attribute

1 Answers  


DRG-12607: only ctxsys can create MULTI_COLUMN preferences

1 Answers  


Categories