在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