It's not a secret anymore!*
The moose likes JDBC and the fly likes Can I execute Oracle procedures through satement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can I execute Oracle procedures through satement" Watch "Can I execute Oracle procedures through satement" New topic
Author

Can I execute Oracle procedures through satement

Ann Sebastian
Ranch Hand

Joined: Sep 21, 2005
Posts: 37
I need to execute Oracle procedure through statement rather than using CallableStatement..Is there some way to do this
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Which Oracle procedures are you referring to?
While I do not recommend this, it is often possible to cast to the specific Oracle type and use the 'Oracle extensions' to perform some Oracle specific behaviour. These are just extra methods hidden by the JDBC interface.
Ann Sebastian
Ranch Hand

Joined: Sep 21, 2005
Posts: 37
The procedures are database stored procedures which I have to access through jdbc statement .I want to use Statement instead of CallableStatement
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Then you should use CallableStatement. 'Not wanting to' is not a good reason not to use it
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can I execute Oracle procedures through satement
 
Similar Threads
Telnet client from webapp [was: Help needed in jsp and beans]
The result set is closed exception.
tomcat and oracle 8i.
executing PL/SQL through JDBC
how to execute .sql file using java