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 |
DRG-12006: Plase enter account:
ORA-23395: object "string"."string" of type "string" does not exist or is invalid
O2I-00117: Internal error: No message file for component O2U
ORA-24777: use of non-migratable database link not allowed
RMAN-08058: replicating controlfile
ORA-30658: attempt was made to create a temporary table with EXTERNAL organization
ORA-29892: indextypes with array DML do not support the given data type
PROT-00707: Cluster registry integrity check failed
NID-00311: Control File string - modified
ORA-31406: change source string is referenced by a change set
ORA-14016: underlying table of a LOCAL partitioned index must be partitioned
ORA-10634: Segment is already being shrunk