Cannot find the procedure or function sp_getLeaveReqId

Question

0.00/5 (No votes)

See more:

Hi
I have created a routine and it gets executed and it is there in the list of routines in my database but when i rum my application i am getting the exception function or procedure sp_getLeaveReqId cannot be found in the data base

C#

int leaveReqId = 0;
        Con = new MySqlConnection(conn);
        Con.Open();
        MySqlCommand cmdLeaveReqId = new MySqlCommand("sp_getLeaveReqId",Con);
        cmdLeaveReqId.Parameters.Add("@AssociateId", MySqlDbType.Int32).Value = Convert.ToInt32(strAssId.Trim());
        cmdLeaveReqId.Parameters.Add("@leaveType", MySqlDbType.String).Value = strLeaveType.Trim();
        cmdLeaveReqId.Parameters.Add("@leaveStatus", MySqlDbType.String).Value = strLeaveStatus.Trim();
        cmdLeaveReqId.CommandType = CommandType.StoredProcedure;
        MySqlDataReader drLeaveReqId = cmdLeaveReqId.ExecuteReader();
        drLeaveReqId.Read();
        leaveReqId = Convert.ToInt32(drLeaveReqId["leave_req_id"].ToString().Trim());
        Con.Close();
        return leaveReqId;

Routine:

C#

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_getLeaveReqId`(In AssociateId integer,In leaveType varchar(45),in leaveStatus varchar(45))
BEGIN
select leave_req_id from leave_request where leave_type_id = (select leave_type_id 
from leave_type where leave_type=leaveType) 
and leave_status_id=(select leave_status_id from leave_status where leave_status=leaveStatus) 
and associate_id=AssociateId;
END

Pl tell me where i went wrong

Posted 18-Jan-12 0:37am

Shashwath7

Updated 18-Jan-12 1:05am

v3

Add a Solution

Comments

AmitGajjar 18-Jan-12 6:50am

show us your code from your SP get called.

Shashwath7 18-Jan-12 7:05am

hi this is my code from which i am calling my stored procedure

int leaveReqId = 0;
Con = new MySqlConnection(conn);
Con.Open();
MySqlCommand cmdLeaveReqId = new MySqlCommand("sp_getLeaveReqId",Con);
cmdLeaveReqId.Parameters.Add("@AssociateId", MySqlDbType.Int32).Value = Convert.ToInt32(strAssId.Trim());
cmdLeaveReqId.Parameters.Add("@leaveType", MySqlDbType.String).Value = strLeaveType.Trim();
cmdLeaveReqId.Parameters.Add("@leaveStatus", MySqlDbType.String).Value = strLeaveStatus.Trim();
cmdLeaveReqId.CommandType = CommandType.StoredProcedure;
MySqlDataReader drLeaveReqId = cmdLeaveReqId.ExecuteReader();
drLeaveReqId.Read();
leaveReqId = Convert.ToInt32(drLeaveReqId["leave_req_id"].ToString().Trim());
Con.Close();
return leaveReqId;

AmitGajjar 18-Jan-12 7:07am

also try with database name, like DBName.sp_getLeaveReqId.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arun Varghese · Answer 1 · 2012-01-18T00:57:00

Solution 1

You can simply define a Short procedure by
CREATE PROCEDURE PROCEDURENAME(@coloumn1 datatype,@coloumn2 datatype)
as
Select @coloumn1,@coloumn2 from tablename

Try this out this might work

Posted 18-Jan-12 0:57am

Arun Varghese