aspose file tools*
The moose likes Oracle/OAS and the fly likes java.sql.SQLException: ORA-00900: invalid SQL statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "java.sql.SQLException: ORA-00900: invalid SQL statement" Watch "java.sql.SQLException: ORA-00900: invalid SQL statement" New topic
Author

java.sql.SQLException: ORA-00900: invalid SQL statement

karthik Suryanarayanan
Ranch Hand

Joined: Oct 07, 2009
Posts: 115

Hi Guys,
When i try to execute a procedure from my java code i get the following error.



My code is as follows


When i execute my procedure independently in Oracle SQL Developer , it runs fine but when i call it through Java , it fails..
Any possible reasons. I have also checked the user privileges and found it to be fine.


"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
karthik Suryanarayanan
Ranch Hand

Joined: Oct 07, 2009
Posts: 115

In my earlier I have posted , i have mentioned


earlier..

Sorry . Actually it was



The issue got resolved. Thanks guys....
 
 
subject: java.sql.SQLException: ORA-00900: invalid SQL statement