我在運行SP時被這個錯誤困擾，我不知道為什么。請幫助我
錯誤行 AND thlt.CODE = ' || p_CODE|| ' 當 CODE 為 varchar2 時
A_ID NUMBER、P_A_Ids VARCHAR2、v_expression VARCHAR2、p_CODE VARCHAR2
...
OPEN v_cursor FOR
' SELECT thltCt.A_ID A_ID,
Sum( ' || v_expression || ' ) "VALUE"
FROM tableA thlt join tableB thltCt on thlt.ID = thltCt.THLT_ID
WHERE thlt.LS IS NOT NULL
AND thlt.CODE = ' || p_CODE|| '
AND thltCt.A_ID IN (' || P_A_Ids || ' )
GROUP BY (thltCt.A_ID)';
uj5u.com熱心網友回復：
從評論中我認為它會像這樣作業：
' SELECT thltCt.A_ID A_ID,
Sum( ' || v_expression || ' ) "VALUE"
FROM tableA thlt join tableB thltCt on thlt.ID = thltCt.THLT_ID
WHERE thlt.LS IS NOT NULL
AND thlt.CODE = '' ' || p_CODE|| ' ''
AND thltCt.A_ID IN ( ' || P_A_Ids || ' )
GROUP BY (thltCt.A_ID)';
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/361925.html
標籤：甲骨文
下一篇：向多個接收者發送電子郵件程式