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-28168: attempted to grant password-protected role

1 Answers  


ORA-16135: Invalid LOG_ARCHIVE_CONFIG modification while in protected mode

1 Answers  


ORA-32035: unreferenced query name defined in WITH clause

1 Answers  


ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management

2 Answers  


SQL*Loader-00277: Local file specification overrides global file specification.

1 Answers  


NNL-00951: Names created on lookup: number

1 Answers  


LPX-00601: Invalid token in: '~S'

1 Answers  


ORA-30372: fine grain access policy conflicts with materialized view

1 Answers  


ORA-27474: cannot give both an argument name and an argument position

1 Answers  


ORA-24035: AQ agent string is not a subscriber for queue string

1 Answers  


PLS-01903: : non-integer error number

1 Answers  


ORA-30198: reserved for future use

1 Answers  


Categories