• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can I execute Oracle procedures through satement

 
Ann Sebastian
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to execute Oracle procedure through statement rather than using CallableStatement..Is there some way to do this
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Then you should use CallableStatement. 'Not wanting to' is not a good reason not to use it
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic