title: concat sequence next value with string
body: <p>i want the sequence next value to be inserted into table after concatenating with some string value. eg: case12. Here 'case' will be the string and '12' will be the next sequence value.
  i'm trying this code in my jsp page.</p>
  
  <pre><code>String name=request.getParameter("name").toString();
   String pwd=request.getParameter("pass").toString();
  out.print(name+" and "+pwd);
  String add="case";
   PreparedStatement ps = connect.prepareStatement("insert into test(caseid,userid,pass) values('CONCAT('"+add+"',test_seq.nextval)',?,?)");
              ps.setString(1,name);
              ps.setString(2,pwd);
              ps.executeUpdate();
              connect.commit();
              connect.close(); 
  </code></pre>
  
  <p>but, i'm getting this error <code>java.sql.SQLException: ORA-00917: missing comma</code></p>
  
  <p>can anybody tell me the solution for above problem. Any help appreciated.!!</p>