MySQL Forums
Forum List  »  Stored Procedures

Re: Cannot use DELIMITER sentence
Posted by: conor meegan
Date: September 28, 2005 09:29AM

Try this. You are missing BEGIN and END and one semi-colon.

delimiter $$

DROP PROCEDURE IF EXISTS sp_Util_FraseSelectByClave$$

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

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

END$$

delimiter ;

Options: ReplyQuote


Subject
Views
Written By
Posted
2913
September 12, 2005 05:13AM
Re: Cannot use DELIMITER sentence
1954
September 28, 2005 09:29AM
2104
September 29, 2005 10:13AM
2760
September 29, 2005 12:36PM
1850
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.