SQLException caught: ORA-17041: (no message for error) 1

[prav ba]

hi all,
i get this error intermittently. am not sure why this happens. heres my code

        java.sql.Date bill_Date = null;
        String billDate = "17/12/2009";
        String accountNo = "134343";
         String  sql = "select ID from BILL where ACCOUNT_NO = ? and BILL_DATE = ? ";

            ps = this.conn.prepareStatement(sql);

            ps.setString(1, accountNo.trim());

            if (billDate.length() != 0) {
                 try {
            java.util.Date day = dateFormat.parse(val);
            bill_Date = new java.sql.Date(day.getTime());
        } catch (ParseException ex) {
            Logger.getLogger(CacheDBImpl.class.getName()).log(Level.SEVERE, "ParseException while parsing billDate " + ex.getMessage());
        }
            } else {
                Log.log(Level.INFO, "bill date is empty.");
            }

            ps.setDate(2, bill_Date);

            rs = ps.executeQuery();  <-- error thrown at this line

please suggest what could be wrong.


thanks in advance.

[Jan Cumps]

ORA-17041: Missing IN or OUT parameter at index...