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-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression
ORA-38311: cannot purge objects owned by other users
NNL-00002: request argument "string" is not allowed with this operation
ORA-21610: size [string] is invalid
ORA-27488: unable to set string because string was/were already set
ORA-02472: PL/SQL functions not allowed in hash expressions
ORA-19026: EXTRACTVALUE can only retrieve value of leaf node
ORA-02737: osnpcl: cannot tell orapop to exit
ORA-02168: invalid value for FREELISTS
LSX-00013: element "~S" not from Schema of Schemas
ORA-32114: Cannot perform operation on a null LOB