In this post I like to show how to call a stored procedure in Oracle 11g XE performing an insert and an update. To create a stored procedure in Oracle 11g I look for guidance and found at Oracle® Database PL/SQL Packages and Types Reference , and PSOUG Insert and Update . I created the following two procedures: create or replace procedure "INSERT_CUSTOMER" (customer_name IN VARCHAR2, customer_street IN VARCHAR2, customer_city IN VARCHAR2, customer_state IN VARCHAR2, customer_photo IN BLOB) is begin INSERT into customer (name, street, city, state, photo) values (customer_name, customer_street, customer_city, customer_state, customer_photo); end; create or replace procedure "UPDATE_CUSTOMER_ADDRESS" (customer_name IN VARCHAR2, customer_street IN VARCHAR2, customer_city IN VARCHAR2, customer_state IN VARCHAR2, customer_photo IN BLOB) is begin UPDATE customer SET street=customer_street, city=customer_city, state=customer_state WHERE name=customer_name; end; Both are