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

LSX-00342: value of attribute "base" must be a complex type definition

1 Answers  


ORA-36402: (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.

1 Answers  


TNS-00250: Navigator has been started

1 Answers  


ORA-29874: warning in the execution of ODCIINDEXALTER routine

1 Answers  


ORA-31475: redo log catalog contains no metadata for the source table

1 Answers  






PLS-00415: 'string' is an OUT parameter and cannot appear in a function

1 Answers  


ORA-01193: file string is not the same file seen at start of recovery

1 Answers  


QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater

1 Answers  


SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE

1 Answers  


ORA-00079: variable string not found

1 Answers  


ORA-28042: Server authentication failed

1 Answers  


ORA-07631: smcacx: $EXPREG failure

1 Answers  


Categories