Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-06444: %s created with compilation errors

1 Answers  


ORA-07218: slkhst: could not perform host operation

1 Answers  


ORA-29345: can not plug a tablespace into a database using a different character set

1 Answers  


ORA-09968: scumnt: unable to lock file

1 Answers  


IMG-00924: Incorrect parameter specification during CREATE INDEX

1 Answers  






ORA-29358: resource plan string does not exist

1 Answers  


ORA-07453: requested resource manager plan schema does not contain OTHER_GROUPS

1 Answers  


ORA-13711: Some snapshots in the range [string, string] are missing key statistics.

1 Answers  


NZE-28793: variable bind failure

1 Answers  


ORA-00152: current session does not match requested session

1 Answers  


ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file

1 Answers  


ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  






Categories