Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Stored procedures..  RSS feed

 
vgs lemu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have not used stored procedures in JDBC before..
Can anyone brief me on this? (creation, calling, examples, etc.)
Any link or reference will also be helpful.
Thanks...
 
Arjunkumar Shastry
Ranch Hand
Posts: 986
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can create/call stored procedure from java program.While calling stored procedure,first get Connection,then connection.prepareCall("{ call <name of stored procedure>(?,?) }");"?" represents IN parameter if you want to pass argument to stored procedure if any.connection.prepareCall() will return CallableStatement which is subinterface of PreparedStatement.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!