procedure for readimg csv file and loading data to mysql

[Deepak Nayak]

i wrote a command to load data from csv file to mysql table . but when i'm writting same command to put it in a store procedure in windows its showing following error.

ERROR 1314: LOAD DATA is not allowed in stored procedures

---------------------------------------------------------------

SQL Statement:

CREATE PROCEDURE `deepak`.`new_routine` ()

BEGIN

LOAD DATA LOCAL INFILE 'C:/Users/pmcs2/Desktop/CUST12.csv'

INTO TABLE cust

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n' ;

END


-------------------------------

please suggest me what to do.