CREATE OR REPLACE PROCEDURE create_test_v(v_emp_idNUMBER,v_enameVARCHAR2, v_SALARYNUMBER,v_dept_idNUMBER) BEGIN INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;