"select into outfile " issue

[Wamaniyma Akolwa]

Hi

I am running MYSQL 5.0 ON WINXP pro.

I have the following procedure:

DELIMITER $$
DROP PROCEDURE IF EXISTS LSMW_COST_SWITC H $$
CREATE PROCEDURE LSMW_COST_SWITC H()
BEGIN
SELECT * FROM C003_COSTING_LS MW ORDER BY NG_PART ASC limit 100;
SELECT * INTO OUTFILE 'E:/Work/Processed Files/test.txt' FIELDS TERMINATED
BY '|' LINES TERMINATED BY '\r\n' FROM C003_COSTING_LS MW ;

END $$

DELIMITER ;

This fails returning the following error message:
"You have an error in your SQL syntax; check the manual that corresponds to
your MYSQL server version for the right syntax to use near '$$ DELIMITER' at
line 9

If I remove the SELECT INTO... CLAUSE the procedure works just fine.

I have tried the SELECT * INTO OUTFILE 'E:............ . as a simple query ,
and it works just fine.
Can someone pls help?
thanks and greets