[DB-SIG] reg bind variable does not exist exception

[Vasu dha]

Hi 
   
  when i execute the below code
   
  if(userrole_prefix!=null)
     { 
      int length = userrole_prefix.length;
      System.out.println("**************start of query");
      qry = select s_2090_1_user.currval from dual;
  
      logger.info(qry);
      result=pStmt.executeQuery(qry);
      System.out.println("**************Query execution");
      while(result.next())
      {
       userid = result.getString(1);
      }
      System.out.println("User id:1:***********"+userid);
      qry = insert into ppsr_user_prop_mst (user_prop_mst_id,prop_id,userid) values(user_prop_mst_seq.nextval,?,?);
      for(int i=0;i<length;i++)
      {
       System.out.println("The propositions are:"+userrole_prefix[i]);
       System.out.println("User id"+userid);
       pStmt = conn.getConnection().prepareStatement(qry);
       pStmt.setInt(1, Integer.parseInt(userrole_prefix[i]));
       pStmt.setInt(2, Integer.parseInt(userid));
       pStmt.execute(qry);
       
      }
       
     } 
   
  i get bind variable does not exist exception.
  with the SOP given in the code block, the  System.out.println("**************start of query"); gets executed. The first query just gets the user-id and this user id is given as an input to another query that is inserted into another table.
   
  I have declared the connection, result set and all others in the beginning of the method. Its too big n hence not put up here.
   
  Please help in getting this fixed.
   
  Thanks & Regards,
  Vasudha

 				
---------------------------------
 Find out what India is talking about on  - Yahoo! Answers India 
 Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW
 				
---------------------------------
 Find out what India is talking about on  - Yahoo! Answers India 
 Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20060911/091117fd/attachment.htm