Passing db names to a stored proc in MySQL 5

[Rory McKinley]

Hello List

I have tried dynamically assigning a database name to a stored proc via 
its parameter list:

CREATE STORED PROCEDURE testStoredProc (IN test_db_name CHAR)
	BEGIN
	SELECT * FROM test_db_name.test_table;
	END;

MySQL does not resolve test_db_name to the value passed in the 
parameter, and the query fails because there is no database with that name.

Is there any way around this?

Regards

Rory