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

ORA-02195: Attempt to create string object in a string tablespace

1 Answers  


QSM-02129: join or filter condition(s) are complex

1 Answers  


ORA-32033: unsupported column aliasing

3 Answers  


ORA-09775: osnmrs: reset protocol error

1 Answers  


TNS-12635: No authentication adapters available

1 Answers  






IMG-00830: boundary queue is full

1 Answers  


ORA-14637: cannot merge a subpartition with itself

1 Answers  


ORA-07278: splon: ops$username exceeds buffer length.

1 Answers  


ORA-07564: sldext: wildcard in filename or extension

1 Answers  


ORA-39042: invalid transform name string

1 Answers  


KUP-04044: error positioning file string

1 Answers  


ORA-25196: keyword MOVE in ALTER TABLE MOVE must immediately follow <table name>

1 Answers  


Categories