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
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com