CREATE OR REPLACE PROCEDURE p_test(a IN NUMBER,b IN NUMBER) IS
PROCEDURE p_sub(c IN NUMBER) IS
BEGIN
DBMS_OUTPUT.PUT_LINE('a='||a);
DBMS_OUTPUT.PUT_LINE('b='||b);
DBMS_OUTPUT.PUT_LINE('c='||c);
END;
BEGIN
p_sub(3);
END p_test;
/
SET SERVEROUTPUT ON
EXEC p_test(1,2);
DROP PROCEDURE p_test;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/802415/viewspace-853814/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/802415/viewspace-853814/