I have web page which has an array.I want that array to be passed in to stored procedure?Can anybody tell me how to do this?

wen the stored procedure is executed i want the following output.

a[0]=a,a[1]=b,a[2]=c etc...


I'm still not able to pass array in stored procedure(MY SQL).Can please anyone help me..

Have you tried looping through the array and executing the procedure for each index in the array?

Nevermind, misread MY SQL as MS SQL

I tried to do something similar for an SQL Server 2005 project i'm working on but realised creating types (which would solve my problem) wasn't introduced untill the 2008 version.

Take a look at these links:

Link 1

Link 2