Home » SQL & PL/SQL » SQL & PL/SQL » Please help
Please help [message #427274] Wed, 21 October 2009 12:38 Go to next message
sunjitu
Messages: 1
Registered: November 2008
Junior Member
Hi All,

What is the default value that a function should return in Oracle. like if we mention RETURN.

Thanks&Regards,
Regards,

[Updated on: Thu, 22 October 2009 00:45] by Moderator

Report message to a moderator

Re: Please help [message #427276 is a reply to message #427274] Wed, 21 October 2009 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
sunjitu wrote on Wed, 21 October 2009 10:38
Hi All,

What is the default value that a function should return in Oracle. like if we mention RETURN.

Thanks&Regards,
Regards,


NULL




You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Please help [message #427277 is a reply to message #427274] Wed, 21 October 2009 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't use RETURN without an expression in a function.

Try to choose a more meaningful title than "please help" for your topics. It is a stupid title, of course you need help otherwise you didn't post.

Regards
Michel

[Updated on: Wed, 21 October 2009 12:47]

Report message to a moderator

Re: Please help [message #427344 is a reply to message #427274] Thu, 22 October 2009 02:52 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There is no default value for a return in a function.
If you have a function that has a bare RETURN statement in it, you'll get a
PLS-00503: RETURN <value> statement required for this return from function
error when you try to compile it.
Previous Topic: how to select all when value is null
Next Topic: How to pass sql statement between procedure?
Goto Forum:
  


Current Time: Sun Sep 25 19:41:55 CDT 2016

Total time taken to generate the page: 0.17713 seconds