Can Not Alter Stored Procedure

[aozcakir]

I have created stored procedures, I used to be able to alter them.

However today I could not (did not do any change in the settings of the server)

When I click on alter procedure I receive the following reply:

DELIMITER $$

DROP PROCEDURE IF EXISTS `citywin_cwthotels`.`cta_DEL_RoomType`$$

$$

DELIMITER ;

Nothing else.

Have you had an issue like this before, were you able to fix it.

Thanks in advance for your help.

— Aslan Ozcakir

[peterlaursen]

We have no such know issue. If I create the SP `cta_DEL_RoomType` and next click 'alter stored procedure' from I get a editor tab like

Code:

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`cta_DEL_RoomType`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `cta_DEL_RoomType`()
BEGIN
— do nothing;
END$$

DELIMITER;

Please:

1) tell what are the program versions (SQLyog and MySQL) that you use?

2) if you execute “SHOW CREATE PROCEDURE `cta_DEL_RoomType`;” what is returned?

3) try explain EXACTLY what steps to take to reproduce?

[Author]

Posts