例:
CREATE OR REPLACE PROCEDURE myproc(id IN varchar2)
IS
name varchar2(20);
BEGIN
SELECT dname INTO name FROM dept WHERE deptno=id;
DBMS_OUTPUT.PUT_LINE(name);
END myproc;
/
查看错误命令
show errors
show errors procedure myproc;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17255699/viewspace-732496/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17255699/viewspace-732496/