error for stored procedures during migration
Posted by: ujvala ujvala
Date: October 15, 2005 04:35AM

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.

Options: ReplyQuote


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.