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-26036: subpartition load specified but table string is not subpartitioned

1 Answers  


what is error treshold?

1 Answers  


LFI-00008: SLTS's initializing/terminating mutex failed for string.

1 Answers  


LFI-00125: Random access only allowed on fixed length record files.

1 Answers  


DRG-52204: error while registering index

1 Answers  






RMAN-06177: restore not done; all files readonly, offline, or already restored

1 Answers  


PCB-00628: Buffer type is incompatible with LOB type

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


PLS-00538: subprogram or cursor 'string' is declared in an object type specification and must be defined in the object type body

1 Answers  


ORA-26041: DATETIME/INTERVAL datatype conversion error

1 Answers  


QSM-02125: subquery join conditions don't meet requirements for capability

1 Answers  


ORA-02230: invalid ALTER CLUSTER option

1 Answers  


Categories