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

SQL*Loader-00268: UNRECOVERABLE keyword may be used only in direct path.

1 Answers  


PCC-00124: COMMON_NAME option is specified too late

1 Answers  


ORA-09927: Unable to set label of server

1 Answers  


ORA-28046: Password change for SYS disallowed

1 Answers  


ORA-19596: SPFILE already included

1 Answers  






ORA-30941: Cannot specify empty URI for non-default namespace 'string'

1 Answers  


ORA-12092: cannot online redefine replicated table "string"."string"

1 Answers  


ORA-19616: output filename must be specified if database not mounted

1 Answers  


ORA-03240: User's temporary tablespace same as tablespace being migrated

1 Answers  


ORA-15032: not all alterations performed

1 Answers  


RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?

1 Answers  


ORA-32743: command cannot be executed on remote instance

1 Answers  


Categories