Re: Cannot use DELIMITER sentence
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 ;
Subject
Views
Written By
Posted
3187
September 12, 2005 05:13AM
Re: Cannot use DELIMITER sentence
2102
September 28, 2005 09:29AM
2238
September 29, 2005 10:13AM
2905
September 29, 2005 12:36PM
1982
September 30, 2005 06:16AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.