How to pass an Integer Array to a Stored Procedure in mysql?

Follow:
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm[^]

your stored procedure should be like this

CREATE procedure procedure_name
(
@CLAIM_NOS varchar(max)
)
as
declare @sql_query varchar(max)
set @sql_query='select * from table_name where CLAIMNO in ('+@CLAIM_NOS+')'
exec (@sql_query)

here im retrieving id number from gridview,,,

string S_selected_Claimno = "";
S_selected_Claimno = S_selected_Claimno + "'" + dataGridView1.Rows[i].Cells[1].Value + "',"

AT last ur parameter string should be like this (front end parameter format)
'1998102600200003','2000041900200001','333333333333333'

this will work ,,try it
NOTE : bt make sure while checking ur SP is working or not pass parameters in the below format (IN the back end)
'''1998102600200003'',''2000041900200001'',''333333333333333'''

DELIMITER $$
CREATE PROCEDURE `uh46v_order_status_array_to_table`(IN statuses varchar(255))
    NO SQL
BEGIN
DROP TEMPORARY TABLE IF EXISTS oc_order_status_tmp;

SET @sql = CONCAT('CREATE TEMPORARY TABLE IF NOT EXISTS `oc_order_status_tmp` ( 
					PRIMARY KEY (`order_status_id`)
					)  ENGINE=MyISAM
					AS (SELECT `order_status_id`, `name` FROM `oc_order_status` WHERE `language_id` = 1 AND `order_status_id` in (',
					statuses, '
					))');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end$$
DELIMITER ;

Calling

call uh46v_order_status_array_to_table('1,2,3,4,5');
select * from oc_order_status_tmp;

output

+-----------------+------------+
| order_status_id | name       |
+-----------------+------------+
|               1 | Pending    |
|               2 | Processing |
|               3 | Shipped    |
|               5 | Complete   |
+-----------------+------------+