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)
select max(RecordID) into Reco from bugtracker.caserecord

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.

Alim K

Options: ReplyQuote

Written By
Facing error while creating procedure
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.