Why this error???

[Jaime López]

Hi,

I create this Stored Procedure:


CREATE PROCEDURE sp_Foro_ConversacionSelectByCodigo(
pCodigo int
)
SELECT
CodConversacion,
Titulo
FROM
tbConversacion
WHERE
CodConversacion = pCodigo;



When I try to edit it in MySQL Query Browser (Right click over stored procedure and select Edit Procedure option) appears this code:


DELIMITER $$

DROP PROCEDURE IF EXISTS `foro`.`sp_Foro_ConversacionSelectByCodigo`$$
CREATE PROCEDURE `foro`.`sp_Foro_ConversacionSelectByCodigo`(
pCodigo int
)
SELECT
CodConversacion,
Titulo
FROM
tbConversacion
WHERE
CodConversacion = @Codigo$$

DELIMITER ;



And if I execute this code, it returns this 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 $$

DROP PROCEDURE IF EXISTS `foro`.`sp_Foro_ConversacionSelectByCod`at line 1

Error number 1064.



My Server Version is 5.0.12-beta-nt. Server is running over Windows XP SP1 and AMD processor. Also, it happens the same over other AMD processor but more powerful.

Can anyone say to me why it happens????

Thanks in advance.