GeeCON Prague 2014*
The moose likes JDBC and the fly likes Stored procedures.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored procedures.." Watch "Stored procedures.." New topic
Author

Stored procedures..

vgs lemu
Greenhorn

Joined: May 12, 2005
Posts: 2
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

Joined: Feb 28, 2005
Posts: 986
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.


Namma Suvarna Karnataka
 
GeeCON Prague 2014
 
subject: Stored procedures..