Oracle Error ORA-00900
Sandeep Jain
Ranch Hand
Posts: 124
posted 14 years ago
Hello Guys,
I am inserting some values from jsp into oracle and I get this error:- ORA-00900
If i execute the same query from sql plus -it works , i mean the values get inserted in the database.
Any idea as to why this can happpen.???
Any help is appriciated
I am inserting some values from jsp into oracle and I get this error:- ORA-00900
If i execute the same query from sql plus -it works , i mean the values get inserted in the database.
Any idea as to why this can happpen.???
Any help is appriciated
Try and Try Till u succeed<br /> <br />Sandeep Jain
posted 14 years ago
post your java code, so we can have a look at the actual statement. Maybe there is some spacing issues or something else that we might be able to see from the actual code.
for your specific error message, this is what oracle 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.
for your specific error message, this is what oracle 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.
