Mega Code Archive

 

Categories / Oracle PLSQL / Stored Procedure Function

 

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; --