Home » SQL & PL/SQL » SQL & PL/SQL » Passing of a parametrrs to procedure
Passing of a parametrrs to procedure [message #223461] Fri, 09 March 2007 00:35 Go to next message
donind
Messages: 95
Registered: February 2007
Member
How can we send 1000 parametrs in a procedure?
is there any other method to pass parameters without defning 1000 parametrs

Any example really helpful

Re: Passing of a parametrrs to procedure [message #223465 is a reply to message #223461] Fri, 09 March 2007 00:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
use a collection type, such as a pl/sql table or a sql type
Re: Passing of a parametrrs to procedure [message #223635 is a reply to message #223461] Fri, 09 March 2007 21:10 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

yes you can do by using arrays
Re: Passing of a parametrrs to procedure [message #223636 is a reply to message #223461] Fri, 09 March 2007 21:12 Go to previous message
ddkdhar
Messages: 68
Registered: February 2007
Member

check this link
Previous Topic: Running this function resolved with error:ORA-31603...
Next Topic: PL/SQL - Getting counts after Merge Statement completion.
Goto Forum:
  


Current Time: Wed Dec 07 11:01:10 CST 2016

Total time taken to generate the page: 0.08802 seconds