error for stored procedures during migration
hello everybody
i used the code below for a stored procedure to migrate from sql server to mysql.
DELIMITER $$
DROP PROCEDURE IF EXISTS `pubs_dbo`.`title-sp`$$
CREATE PROCEDURE `pubs_dbo`.`title-sp` ()
BEGIN
select title_id,title from `pubs_dbo`.`titles`;
END$$
DELIMITER ;
"the error what i'm getting is :
you have an error in your sql syntax; check your manual for right syntax near 'DELIMITER $$
DROP PROCEDURE IF EXISTS `pubs_dbo`.`title-sp`$$
CREATE PROCEDU"
what i've to do to rectify this error. anybody please help me
ujvala.
Subject
Written By
Posted
error for stored procedures during migration
October 15, 2005 04:35AM
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.