MySQL Forums
Forum List  »  Knowledge Base

Facing error while creating procedure
Posted by: Alim Khan
Date: April 08, 2011 07:13AM

Hi All,
I am very new in MySQL and I am facing problem in creating the OUT procedure. Below is the syntax:

CREATE PROCEDURE maxRec (Reco int)
BEGIN
select max(RecordID) into Reco from bugtracker.caserecord
END;

I am facing an error message :
Category Timestamp Duration Message Line Position
Error 4/8/2011 6:42:16 PM 0:00:00.015 <link> - MySQL Database Error: No database selected 10 0

While I am providing the correct database information.

Please guide in resolving this issue.

Regards,
Alim K

Options: ReplyQuote


Subject
Views
Written By
Posted
Facing error while creating procedure
1201
April 08, 2011 07:13AM


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.