OraFAQ Forum: SQL & PL/SQL » How to Pass array of values in Stored Procedures

Home » SQL & PL/SQL » SQL & PL/SQL » How to Pass array of values in Stored Procedures (Oracle 10g)

Mon, 06 October 2008 09:06

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.

Mon, 06 October 2008 10:00

ehegagoka
Messages: 493
Registered: July 2005

Senior Member

What do you mean by multiple values? an array of string? please post a sample.

Mon, 06 October 2008 10:11

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use a COLLECTION.

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

Regards
Michel

Tue, 07 October 2008 00:00

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

Chk This Out

Regards,
Rajat Ratewal

Tue, 07 October 2008 03:35

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: Fri Jul 11 21:48:18 CDT 2025