File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle Error ORA-00900 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle Error ORA-00900" Watch "Oracle Error ORA-00900" New topic

Oracle Error ORA-00900

Sandeep Jain
Ranch Hand

Joined: Oct 25, 2000
Posts: 124
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

Try and Try Till u succeed<br /> <br />Sandeep Jain
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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.
I agree. Here's the link:
subject: Oracle Error ORA-00900
It's not a secret anymore!