|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
http://www.csis.gvsu.edu/GeneralInf...a96525/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 |
|
#3
|
|||
|
|||
|
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? |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Invalid statement error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|