Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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 The Software Craftsman this week in the Agile 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: 117

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: 117

In my earlier I have posted , i have mentioned


earlier..

Sorry . Actually it was



The issue got resolved. Thanks guys....
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: java.sql.SQLException: ORA-00900: invalid SQL statement