在sql developer中登陆某数据库,在procedure里面加入一个proc,种类选ARBOR:
CREATE OR REPLACE PROCEDURE PROCEDURE23
IS
NAM VARCHAR2(100);
BEGIN
DBMS_OUTPUT.PUT_LINE('NAME:'|| NAM);
END;
sql developer的命令行:
set serveroutput on; DECLARE
NAME1 VARCHAR2(200);
BEGIN
NAME1 := 'a';
execute ARBOR.PROCEDURE23(
NAME => NAME1
);
结果输出了name:a