This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Generally, you'd code your stored procedure (which will probably have as many parameters as needed to do the update), and use a PreparedStatement (or CallableStatement if it is a function or otherwise returns some value) to call it. The details are described in Oracle's JDBC tutorial.
However, updating a single record is easily doable in Java without any help of a stored procedure.