Two Laptop Bag
The moose likes XML and Related Technologies and the fly likes Urgent !!! Prepared Statement Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Reply locked New topic

Urgent !!! Prepared Statement Problem

Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
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,

SJCP 1.4<br />SCWCD 1.4<br />SCEA
Balaji Loganathan
author and deputy

Joined: Jul 13, 2001
Posts: 3150
Please post ur in JDBC forumsomeone there will sure help you.

Spritle Software Blogs
I agree. Here's the link:
subject: Urgent !!! Prepared Statement Problem
It's not a secret anymore!