ps = conn.prepareStatement(" UPDATE USF_HEA_BENEFIT_AMOUNTS
SET " +
" BENEFIT_1_2_AMT = ?, " +
" BENEFIT_3_5_AMT = ?, " +
" BENEFIT_6_PLUS_AMT = ?, "
+
" CREATED_BY = '?' " +
" WHERE " +
" HEA_BENEFIT_CATEGORY_CDE =
'?' AND " +
"
HEA_BENEFIT_FUEL_CATEGORY_CDE = '?' AND " +
" INCOME_LEVEL = ? AND " +
" HEATING_SEASON = ? " );
ps.setInt(1, 5)
ps.setInt(2, 6);
ps.setInt(3, 7]);
ps.setString(4, loginId);
ps.setString(5, "O");
ps.setString(6, "E");
ps.setInt(7, 668);
ps.setInt(8,07 );
count = ps.executeUpdate();
i provide all 8 parameters and the query is working fin in toad
but when i am executing i am getting
java.sql.SQLException: ORA-01006: bind variable does not exist
any suggestions
joeNOSPAM@BEA.com - 19 Sep 2006 15:13 GMT
> ps = conn.prepareStatement(" UPDATE USF_HEA_BENEFIT_AMOUNTS
> SET " +
[quoted text clipped - 27 lines]
>
> any suggestions
Get rid of the quotes around your string parameter markers in the SQL.
Quotes are for literal fixed strings, not variables. All variables are
marked
with plain question marks.
Joe
sunil(nani) - 19 Sep 2006 15:26 GMT