Re: PROBLEM IN ROUTINE MIGRATION

[Michael G. Zinner]

Hi.

Yes, 5.0 does support stored procedures. But you have to use the SQL standard syntax (that is also used by DB2). You cannot execute Oracle PL/SQL procedures or TSQL procedures from MS SQL Server. You have to convert them first.

A simple stored procedure looks like this:

DELIMITER $$

DROP PROCEDURE IF EXISTS `scott`.`title-sp`$$
CREATE PROCEDURE `scott`.`title-sp` ()
BEGIN
select title_id,title from `scott`.`titles`;
END$$

DELIMITER ;

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification