Missing Comma Error


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Missing Comma Error

Hybrid View

  1. #1
    Join Date
    Apr 2011
    Posts
    1

    Question Missing Comma Error

    Hello,

    I get the error "java.sql.SQLException: ORA-00917: missing comma" when i execute the below insert statement.

    stat.executeQuery("insert into sla values('','"+project_id+"','0','18-APR-11','"+bn.getSelectedPG()+"','"+Process+"','"+tot_vol+"','"+DefectOntime+"','"+DefectOntim e+"','"+DefectFree_Failed+"','"+DefectFree_Failed+"','"+CurrentDate+"','"+userID+"','"+Cur rentDate+"','"+userID+"',''");

    It execute fine when i execute it in DB. I checked the value of variables inside insert statement, nothing looks wrong... Kindly help.

    Thanks in Advance,
    Deepakkumar.

  2. #2
    Join Date
    Apr 2011
    Posts
    1
    This issue is resolved. I missed the close parenthesis for the insert statement. The error "Missing Comma" diverted me.

Similar Threads

  1. Replies: 12
    Last Post: 10-24-2008, 03:15 PM
  2. Replies: 5
    Last Post: 01-17-2007, 02:37 PM
  3. I can't link FreeImage to C#
    By mesh2005 in forum .NET
    Replies: 1
    Last Post: 03-06-2006, 09:16 AM
  4. Re: Error handling in components called from ASP
    By James Barbetti in forum ASP.NET
    Replies: 2
    Last Post: 11-06-2001, 02:13 PM
  5. Winsock32, Connect fails to connect to a peer
    By Chris.G in forum VB Classic
    Replies: 4
    Last Post: 11-13-2000, 04:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center