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

LPX-00226: entity "~S" is not declared

1 Answers  


ORA-24098: invalid value string for string

1 Answers  


ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


TNS-12214: TNS:missing local communities entry in TNSNAV.ORA

1 Answers  


RMAN-06430: recovery catalog userid cannot be SYS

1 Answers  






ORA-09340: Specified ORACLE_SID is either invalid or too long

1 Answers  


ORA-39136: cannot specify an SCN on a transportable job

1 Answers  


ORA-30117: syntax error at 'string' at the start of input

1 Answers  


ORA-27157: OS post/wait facility removed

1 Answers  


RMAN-06543: duplicate or conflicting LIST options: string and string

1 Answers  


LSX-00145: attribute "~1S" invalid derived value "~2S"

1 Answers  


PLS-00220: simple name required in this context

1 Answers  


Categories