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
clsApproveOrRejectBAL objApproveOrReject = new clsApproveOrRejectBAL();
LinkButton lnkApprove = (LinkButton)sender;
GridViewRow gvRowApprove = (GridViewRow)lnkApprove.NamingContainer;
LinkButton lnkAssid = (LinkButton)gvRowApprove.FindControl("lnkAssId");
Label lblleaveType = (Label)gvRowApprove.FindControl("lblLeaveType");
int leaveId = objApproveOrReject.getLeaveReqId(lnkAssid.Text.Trim(), "pending", lblleaveType.Text);
objApproveOrReject.ApproveLeave(Session["userId"].ToString(), Session["userId"].ToString(), lnkAssid.Text.Trim(), 1);
Routine:
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