PLS-00503: RETURN <value> statement required for this return
from function



PLS-00503: RETURN <value> statement required for this return from function..

Answer / guest

Cause: In a function body, a RETURN statement was used that
contains no expression. In procedures, a RETURN statement
contains no expression because the statement simply returns
control to the caller. However, in functions, a RETURN
statement must contain an expression because its value is
assigned to the function identifier.

Action: Add an expression to the RETURN statement.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06565: WARNING: string: sqlcode number was caught, automatic retry #number

1 Answers  


CLSR-00002: Oracle error encountered while executing string

1 Answers  


ORA-09366: Windows 3.1 Two-Task driver unable to allocate shared memory

1 Answers  


ORA-09762: sNeXT_instanceName: translation error.

1 Answers  


ORA-00161: transaction branch length string is illegal (maximum allowed string)

1 Answers  


NID-00306: Datafile string - no revert needed

1 Answers  


NNL-00278: Maximum number of times a request can be reforwarded is now number

1 Answers  


ORA-26701: STREAMS process string does not exist

1 Answers  


PLS-01463: STDDEV is not a standard set function

1 Answers  


PLS-00131: Pragma string expects 2nd argument to be a procedure

1 Answers  


ORA-39114: Dump files are not supported for string jobs

1 Answers  


ORA-02420: missing schema authorization clause

1 Answers  


Categories