Stored Procedure Function Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Stored Procedure Function
  4. AUTHID clause in a CREATE PROCEDURE statement indicates that this procedure is being created with users or invok
CREATE OR REPLACE PROCEDURE delete_emp (p_emp_id number)
AUTHID current_user IS
BEGIN
    DELETE FROM emp WHERE emp_id = p_emp_id;
COMMIT;
END;
--