November 19th, 2003, 02:12 PM
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?
November 19th, 2003, 02:52 PM
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.
November 19th, 2003, 03:03 PM
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?