Creating Stored Procedures in TOAD

[cmitsys]

Ok, let me start off by saying that I can already create a stored procedure from the MYSQL command line, what I want to figure out is how to create a stored procedure using TOAD.

I can take the exact same code I would use at the commnd line and paste that into TOAD's procedure builder, but I get an error.

Here is a sample Stored Procedure script, followed by the error. I believe I am building these procedures with the same user (root) in both the command line method and when in TOAD.

------------------
USE HWRTEST_DB;

DELIMITER //

CREATE PROCEDURE sp_settings ()
BEGIN
select * from settings;
END;
//

DELIMITER ;
------------------


ERROR:
Statusbar: 12/28/2006 11:40:29 PM: MySQL Database Error: No database selected


Anyone ever been able to use TOAD to create a stored procedure? If so can you please give me some guidance. Is tis a security issue, or something else?

Regards,
Charlie

 

[mbrooks]

According to the log error above, you have not selected a database.

MySQL Database Error: No database selected

Check your database name entry for case-sensitivity.

M. Brooks

http://mbrooks.info