MySQL Forums
Forum List  »  Stored Procedures

Re: what is the equivalent to EXEC()
Posted by: William Chiquito
Date: May 07, 2007 07:34AM

Hi Hugues,

The equivalent of EXEC (MSSQL Server) is Prepared Statements.

e.g.:
DELIMITER $$

DROP PROCEDURE IF EXISTS `sptest`$$

CREATE PROCEDURE `sptest`()
BEGIN
	PREPARE stmt1 FROM 'SELECT "ok"';
	EXECUTE stmt1;
	DEALLOCATE PREPARE stmt1;
END$$

DELIMITER ;

call sptest();
Result:
ok    
------
ok

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: what is the equivalent to EXEC()
17884
May 07, 2007 07:34AM
6980
July 30, 2007 08:10AM
3898
August 01, 2007 10:06AM


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.