This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
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 Soft Skills this week in the Jobs Discussion 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