Home » SQL & PL/SQL » SQL & PL/SQL » procedure in out (oracle9i)
procedure in out [message #389771] Tue, 03 March 2009 09:14 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
While creating procedure with one In parameter and one OUT parameter ,is it better to use two individual parameters IN and OUT or IN OUT,which one is better why?
Re: procedure in out [message #389772 is a reply to message #389771] Tue, 03 March 2009 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>While creating procedure with one In parameter and one OUT parameter ,is it better to use two individual parameters IN and OUT or IN OUT,which one is better why?
Better? Based upon which metric?
It depends upon your actual requirements.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

[Updated on: Tue, 03 March 2009 09:16]

Report message to a moderator

Re: procedure in out [message #389780 is a reply to message #389772] Tue, 03 March 2009 09:49 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If the procedure takes a value in as an IN parameter, and returns a value that you want to use (as opposed to a completion status) in an OUT variable, then I'd rewrite it as a function.
Re: procedure in out [message #389786 is a reply to message #389771] Tue, 03 March 2009 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No one is better.

ONCE AGAIN, GIVEN YOUR LEVEL, POST ALL YOUR QUESTIONS IN HOMEWORK FORUM.

Regards
Michel
Re: procedure in out [message #389790 is a reply to message #389786] Tue, 03 March 2009 10:09 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
which one is better why?


That question makes about as much sense as "Which is better, a firetruck or an amulance?"

Which would depends mainly yon wheter you are injured or your house is on fire.
Re: procedure in out [message #389792 is a reply to message #389790] Tue, 03 March 2009 10:10 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
ThomasG wrote on Tue, 03 March 2009 16:09
Quote:
which one is better why?


That question makes about as much sense as "Which is better, a firetruck or an amulance?"

Which would depends mainly yon wheter you are injured or your house is on fire.

Or Both!
Re: procedure in out [message #389902 is a reply to message #389786] Wed, 04 March 2009 00:48 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Tue, 03 March 2009 16:59
No one is better.

ONCE AGAIN, GIVEN YOUR LEVEL, POST ALL YOUR QUESTIONS IN HOMEWORK FORUM.

Regards
Michel


Level has nothing to do with the appropriate forum.
Homework forum is for homework questions.
Re: procedure in out [message #389911 is a reply to message #389771] Wed, 04 March 2009 01:38 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Ramesh,

Why don't you try to put the question with whatever you tried, or whatever you want to try rather than putting just 1-2 lines here.

Selecting Parameter Modes is based on your requirement.

IN Parameter Mode - > Is used to get the values to the Stored Procedure

OUT Parameter Mode - > Is used to pass the value from the stored Procedure

IN OUT Parameter Mode - > Is used to get and send the value in a single variable ( Parameter)

Why don't you study about this before posting here. Its just a suggestion for you to improve.

Regards,
Ashoka BL
Re: procedure in out [message #389920 is a reply to message #389902] Wed, 04 March 2009 02:28 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Frank wrote on Wed, 04 March 2009 07:48
Level has nothing to do with the appropriate forum.
Homework forum is for homework questions.

It was a short-cut for "given your level and the fact that you don't know the type of questions you post and that you are training..."
And "homework forum" was a short-cut for "homework, training and ... forum".
As I already said him this in long version in other topics, I think (may I should not) he will understand (even if others misundertood it).

Regards
Michel
Previous Topic: desc table
Next Topic: Column to Row
Goto Forum:
  


Current Time: Sun Dec 11 04:04:38 CST 2016

Total time taken to generate the page: 0.27050 seconds