Home » SQL & PL/SQL » SQL & PL/SQL » Why we not use out parameter in pl/sql function
Why we not use out parameter in pl/sql function [message #617875] Fri, 04 July 2014 03:08 Go to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Hi Guys,

What is problems when we used out parameter in pl/sql function.
Re: Why we not use out parameter in pl/sql function [message #617877 is a reply to message #617875] Fri, 04 July 2014 03:16 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can't use such a function in a SQL statement.
Re: Why we not use out parameter in pl/sql function [message #617885 is a reply to message #617877] Fri, 04 July 2014 03:47 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Thank you so much cookiemonter.
Re: Why we not use out parameter in pl/sql function [message #617938 is a reply to message #617885] Fri, 04 July 2014 10:32 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Aaditya,

I guess you did not do preliminary search before asking your doubt. I did a search in google and got this Orafaq link on top with several other links with plenty of useful answers. Have a look http://www.orafaq.com/forum/t/160414/0/

See, a couple of weeks ago you posted a similar question http://www.orafaq.com/forum/m/613072

I am not saying you shouldn't ask such a question, but it seems to be too basic in nature. If you would have posted a test case and ask about the pros and cons of OUT parameter in a function, it would have been nice to see. Just a suggestion, lest CM's reply and the link I posted should help you to understand the topic completely.
Re: Why we not use out parameter in pl/sql function [message #617947 is a reply to message #617938] Fri, 04 July 2014 23:54 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Lalit I searched it in my end but not got satisfied answers.
Re: Why we not use out parameter in pl/sql function [message #617948 is a reply to message #617947] Sat, 05 July 2014 00:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Lalit I searched it in my end but not got satisfied answers.

how are we to know what would be "satisfied answers" for you?

>What is problems when we used out parameter in pl/sql function.
There is NO problem.
Now prove me wrong if you can or care to waste more time on this triviality.
Re: Why we not use out parameter in pl/sql function [message #617951 is a reply to message #617948] Sat, 05 July 2014 01:47 Go to previous message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Which answers we can get easily that is known as satisfied answers.
Previous Topic: Generate Graph using PL SQL
Next Topic: How to insert data in another table
Goto Forum:
  


Current Time: Thu Mar 28 10:06:11 CDT 2024