This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
 
subject: Can I execute Oracle procedures through satement
 
It's not a secret anymore!