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

NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string

1 Answers  


SQL*Loader-00514: Error getting elapsed time

1 Answers  


ORA-21704: cannot terminate cache or connection without flushing first

1 Answers  


PCB-00235: Table size mismatch in INTO/USING. Minimum is: number

1 Answers  


PLS-00630: pipelined functions must have a supported collection return type

2 Answers  






ORA-38717: Invalid DUMP FLASHBACK option.

1 Answers  


ORA-19861: additional backup pieces cannot be validated in this conversation

1 Answers  


ORA-30335: JOIN KEY clause references a level not in this hierarchy

1 Answers  


ORA-33460: (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.

1 Answers  


ORA-31153: Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"

1 Answers  


PLS-00258: constrained datatypes disallowed in CALL Specifications

1 Answers  


ORA-12597: TNS:connect descriptor already in use

1 Answers  


Categories