.net 中ibatis调用mysql存储过程
Mysql存储过程:
create procedure GetTicketData ( ProjectCode VARCHAR(50) )
begin SET @sql_1="";
SET @sql_1 = concat("CREATE TEMPORARY TABLE tmp_table SELECT a.StoreComplainID,a.id as StoreLevelComplainID,sc.DateRound,a.CategoryName,sc.Store_Code,sc.Store_Name,a.Fact_Code,a.Fact_Name,a.Item_Name,a.Content, a.HandleResult, (case sc.Escalated when 1 then '释放' else '未释放' end Escalate, sc.T1Escalate_Remark,sc.T2Escalate_Remark,DATE_FORMAT(sc.ComplainTime,'%Y-%m-%d') as ComplainTime
from t_storelevelcomplain a
LEFT JOIN t_storecomplain sc on a.StoreComplainID=sc.ID
where sc.Project_Code = ",'"',ProjectCode,'"');
PREPARE stmt FROM @sql_1;
EXECUTE stmt;
SELECT * from tmp_table;
drop TABLE tmp_table;
end
在mysql里面可以正常执行,但放到程序里就会报错。
xml中的代码:
{call GetTicketData($ProjectCode$)}
执行mysql时,传入的参数是:'P01',程序中传入的参数也是'P01',可程序中就是会报错,请问,有没有遇到过这个问题的园友?帮忙解答一下,谢谢!