Kettle Spoonの実行SQLスクリプトコンポーネントレポート「無効な識別子」エラー解決


データソース:Oracle 10 g
2013/08/24 17:07:49 -        .0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :           !
2013/08/24 17:07:49 -        .0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
2013/08/24 17:07:49 -        .0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Couldn't execute SQL: DELETE FROM MS_SD_RT WHERE SOUR_ORG_NO = '31101' and STD_TYPE=aa
2013/08/24 17:07:49 -        .0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
2013/08/24 17:07:49 -        .0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : ORA-00904: "AA":      

解決策:コンポーネント内のsql条件パラメータ(?で表す)を一重引用符(例えば:DELETE FROM MS_SD_RT WHERE SOUR_ORG_NO='31101'and
std_TYPE='?')