Home » SQL & PL/SQL » SQL & PL/SQL » IN OUT parameter (Oracle 10g)
IN OUT parameter [message #320724] Fri, 16 May 2008 01:46 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
in ideal case how many in out parameter we should keep for procedure
Re: IN OUT parameter [message #320726 is a reply to message #320724] Fri, 16 May 2008 01:48 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
As many as are required
Re: IN OUT parameter [message #320732 is a reply to message #320726] Fri, 16 May 2008 02:18 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
It All Depends , if u dont like to use too many ,
use table of records or arrays ,
but care to handle them.
Re: IN OUT parameter [message #320829 is a reply to message #320732] Fri, 16 May 2008 06:47 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The decision to use collections as OUT parameters should not be based on the number of OUT parameters, but on the fact whether or not they are related.
Previous Topic: ORA_ROWSCN functionality
Next Topic: Single Index with many columns or Multiple Indexes with fewer columns?
Goto Forum:
  


Current Time: Sat Dec 03 08:25:22 CST 2016

Total time taken to generate the page: 0.10907 seconds