Only 44 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!

Win a copy of Murach's Python Programming this week in the Jython/Python forum!
    Bookmark Topic Watch Topic
  • New Topic

Urgent !!! Prepared Statement Problem  RSS feed

Shanmugam Muthukumarasamy
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi All,
In my application, at runtime, I am getting the following exception:
Description: Class: FdpMbrDatesData Method: executeQuery() : SQLException
java.sql.SQLException: ORA-01008: not all variables bound
I am not able to guess what is the problem with the following portion of the code.
pstmt = rO_conn.prepareStatement(lS_SQLStatement);

pstmt = this.setBindParams(pstmt);

int ii_position = 1;
//set timestamp of query; Take stamp before query as this is the most conservative view
super.setSQLDateTimeStamp(new java.util.Date());
rs = pstmt.executeQuery();

While crossing the "pstmt.executeQuery()" it is throwing the above exception.
It is very Urgent...If any body have any idea please let me know.
Thanks in advance,
Balaji Loganathan
author and deputy
Posts: 3150
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please post ur in JDBC forumsomeone there will sure help you.
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!