MySQL Forums
Forum List  »  Stored Procedures

Cannot use DELIMITER sentence
Posted by: Jaime López
Date: September 12, 2005 05:13AM

When I try to create one stored procedure with the code below, it fails in first line. The error says that delimiter is not a good command, it doesn't recognize delimiter as a command.

Do you know what is going wrong with this????

I use MySQL Server 5.0.12 and MySQL Query Browser with root user for everything at the moment.

Code:

delimiter $$

DROP PROCEDURE IF EXISTS sp_Util_FraseSelectByClave$$

CREATE PROCEDURE sp_Util_FraseSelectByClave(
pNotacion varchar,
pIdioma int,
pAplicacion varchar
)

SELECT
Notacion,
CodIdioma,
Aplicacion,
Texto,
FCCreacion,
FCModificacion
FROM
tbFrase
WHERE
Notacion = pNotacion AND
CodIdioma = pIdioma AND
Aplicacion = pAplicacion

$$

delimiter ;

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot use DELIMITER sentence
2892
September 12, 2005 05:13AM
1946
September 28, 2005 09:29AM
2098
September 29, 2005 10:13AM
2754
September 29, 2005 12:36PM
1844
September 30, 2005 06:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.