stored procedure creating problem?

[Wumchi]

Hi folks,
I found a problem with a stored procedure, crashing the MySQL broswer.
The stored procedure looks as:

DELIMITER $$

DROP PROCEDURE IF EXISTS `tc`.`GTH` $$
CREATE PROCEDURE `GTH`(IN origID INT)
BEGIN

// create and fill a table called tempT
CREATE TEABLE tempT...

//perform a SELECT statement using tempT, let the returnset be returned
SELECT *
FROM A a, B b, tempT tt
WHERE a.ID = b.ID
AND a.ID = tt.id;

END $$
DELIMITER ;

So, what might be the problem?
Thanks in advance!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try the latest release of QB to build and run SP's. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --