How to execute stored procedure?
Stored procedure are user-generated functions or procedures that, once created in the database, can be called by the client applications, such as Java application. In this example we'll demonstrate how to use the JDBC
java.sql.CallableStatement to call a stored procedure.
The store procedure in this example is just for inserting a record into table. Just like the
PreparedStatement interface, in the
CallableStatement we can pass the parameter to the procedure by calling the appropriate
setXXX(index, value) method.
Below is the stored procedure that was executed in the code above.
CREATE OR REPLACE PROCEDURE CREATE_USERS (username IN VARCHAR2, password IN VARCHAR2, firstName IN VARCHAR2, lastName IN VARCHAR2, address IN VARCHAR2, email IN VARCHAR2) AS
INSERT INTO users (username, password, first_name, last_name, address, email) VALUES (username, password, firstName, lastName, address, email);