SQL> CREATE OR REPLACE PROCEDURE AddNewEmployee (<br />
p_FirstName employee.first_name%TYPE,<br />
p_LastName employee.last_name%TYPE,<br />
p_Salary employee.salary%TYPE) AS<br />
BEGIN INSERT INTO employee (ID, first_name, last_name,<br />
salary)<br />
VALUES (student_sequence.nextval, p_FirstName, p_LastName,<br />
p_Salary);<br />
COMMIT;<br />
END AddNewEmployee;<br />
/
You can see full example
Oracle Stored Procedure[
^]