Home » SQL & PL/SQL » SQL & PL/SQL » How to Pass array of values in Stored Procedures (Oracle 10g)
How to Pass array of values in Stored Procedures [message #352179] Mon, 06 October 2008 09:06 Go to next message
sanyadu
Messages: 30
Registered: October 2006
Location: Chicago
Member
Hi ,

I am trying to pass multiple values dynamically into a stored procedure .

Please help me how will I perform the same.

Sandeep.
Re: How to Pass array of values in Stored Procedures [message #352191 is a reply to message #352179] Mon, 06 October 2008 10:00 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
What do you mean by multiple values? an array of string? please post a sample.
Re: How to Pass array of values in Stored Procedures [message #352194 is a reply to message #352179] Mon, 06 October 2008 10:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a COLLECTION.

PL/SQL User's Guide and Reference
Chapter 5 Using PL/SQL Collections and Records

Regards
Michel
Re: How to Pass array of values in Stored Procedures [message #352290 is a reply to message #352194] Tue, 07 October 2008 00:00 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Chk This Out

Regards,
Rajat Ratewal
Re: How to Pass array of values in Stored Procedures [message #352339 is a reply to message #352194] Tue, 07 October 2008 03:35 Go to previous message
sanyadu
Messages: 30
Registered: October 2006
Location: Chicago
Member
Thanks it works
Previous Topic: Select where date equal today's date
Next Topic: error while inserting into table
Goto Forum:
  


Current Time: Sun Dec 11 00:42:50 CST 2016

Total time taken to generate the page: 0.17001 seconds