MySQL ERROR : column EnquiryNo cannot be null

Last Reply on Feb 13, 2014 02:05 AM By kalpesh

Posted on Feb 12, 2014 11:15 PM

i have a stored procedure in Mysql while i execute the procedure i get this error even am having the values in the query.

CALL sptblEnquiryMaster ('Offer/0011/2013-2014','demo/001','2014','1','1','0','1','1','1','jkn','jkn','nn','1',
'1','ADD','hjbj',@PMasterSID)

ERROR : column 'EnquiryNo ' cannot be null 

Posted on Feb 13, 2014 02:05 AM

Check the stored procedure if affected table contain EnquiryNo column and column is Not Null then you should insert value for EnquiryNo on stored procedure level.

If you are passing value for EnquiryNo Then check the parameters which you are passing  .