#1
  1. No Profile Picture
    almost there....
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    A Red Glitter Coffin
    Posts
    140
    Rep Power
    0

    Invalid statement error


    I'm executing this from a java program:

    c.runSQLQuery("INSERT INTO studentmembers " + "VALUES('JoeDuffy', 'Joe@joe.com', 21, 'M', 46617878, 'CA')");

    Its inserting the data and it appears int the database but it gives an SQL Exception back saying

    0RA-00900: invalid SQL statement

    but the data goes in fine as i can see, this has been annoying me for a week and i've tried so many little things that could be wrong, semicolons and the like, anyone know whats wrong here?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    http://www.csis.gvsu.edu/GeneralInfo...96525/e900.htm says:

    ORA-00900 invalid SQL statement
    Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.
    Action: Correct the syntax or install the Procedural Option.

    Doesn’t seem to shed much light on your problem.

    Regards,
    Dan
  4. #3
  5. No Profile Picture
    almost there....
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    A Red Glitter Coffin
    Posts
    140
    Rep Power
    0
    ya, well i guess it is the syntax

    just don't know how to fix it, the confusing thing is that it goes into the database, any ideas on whats wrong?

IMN logo majestic logo threadwatch logo seochat tools logo