Win a copy of OCP Java SE 8 Programmer II Exam Study Guide this week in the OCP forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Callable Statement  RSS feed

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
How can we call callable statements and stored procedures from java.

Vivek
 
drifter
Ranch Hand
Posts: 1364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Seems like I found an example in oracle's sample code, but I don't see it withat quick search. However, here's
one google result.

Here are a couple of real examples. Hopefully I didn't butcher them copy/pasting only the essential lines

Call stored simple proc, not expecting anything back from it:


More complex example with out parameters including refcursor:
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!