Error in MySQL StoredProc

[JSPRookie]

Hi all,

I have this error upon creation of SP "MySQL Error Number 1046, No Database selected".. Im using mysql-5.0.24

My Code is below.

CREATE PROCEDURE `MyTestDB`.`spTest` ()
BEGIN
SELECT * from tblPort
END;

I hope someone can help me.. Thank in advance :)

[chazzy]

try issuing a use `MyTestDB`; statement first and see if there's a difference.