This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 110

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

In my earlier I have posted , i have mentioned


earlier..

Sorry . Actually it was



The issue got resolved. Thanks guys....
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: ORA-00900: invalid SQL statement
 
Similar Threads
Callign an oragle package in Java with JDBC
Passing specific format date to callable statement
Determine the Callable Statements Parameters at runtime
invalid host/bind variable name
Strange oracle problem--plz HELP