| procedure in out [message #389771] |
Tue, 03 March 2009 09:14  |
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  |
 |
BlackSwan
Messages: 26766
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 |
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 #389790 is a reply to message #389786] |
Tue, 03 March 2009 10:09 |
ThomasG
Messages: 3212
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 |
pablolee
Messages: 2882
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 |
Frank
Messages: 7901
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 |
|
|
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 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
