Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00372: In a procedure, RETURN statement cannot contain
an expression
- 1 Answers
- 7705 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-02074: cannot string in a distributed transaction
ORA-29883: cannot create a domain index on column expressions
TNS-04044: Specified gateways do not exist.
RMAN-06034: at least 1 channel must be allocated to execute this command
NNL-00831: Deletes refused, name is not a leaf name: number
TNS-00312: Connection Manager: Failed to get version information
ORA-22996: NEXT extent size is smaller than LOB chunksize
ORA-19554: error allocating device, device type: string, device name: string
LPX-00604: Invalid attribute value '~1S', for attribute '~2s'.
UDE-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.
PCB-00636: This attribute is only valid for External LOB types
RMAN-06545: "string" is an invalid response - please re-enter.
Oracle Errors 
