Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Error ORA-00900

 
Sandeep Jain
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic