aspose file tools*
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
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
 
Don't get me started about those stupid light bulbs.
 
subject: Can I execute Oracle procedures through satement