![](https://csdnimg.cn/release/download_crawler_static/86963837/bg9.jpg)
带输入参数的过程3-2
CREATE OR REPLACE PROCEDURE sp_dept_insert
(i_deptno NUMBER,
i_dname VARCHAR2,
i_loc VARCHAR2)
AS
BEGIN
INSERT INTO dept VALUES(i_deptno,i_dname,i_loc);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('添加失败!原因为:'||SQLERRM);
ROLLBACK;
END sp_dept_insert;
oracle存储过程函数和程序包