Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00372: In a procedure, RETURN statement cannot contain
an expression
- 1 Answers
- 7786 Views
- I also Faced
- E-Mail Answers
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-16617: unknown object identifier specified in request
DRG-10101: no value for argument: string
ORA-16202: Skip procedure requested to replace statement
PCC-02395: Using arrays of structs requires that the struct be named
ORA-26507: null master connection
DRG-10553: illegal syntax for column specification string
ORA-31446: this session does not own the lock handle for string
NNL-00997: NO SUCH NAME responses received: number
TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.
ORA-28101: policy already exists
PLS-00729: only widening of the collection element type is allowed
ORA-22347: No changes to type specified for ALTER TYPE
Oracle Errors 
