例1
CREATE OR REPLACE PROCEDURE proaaa
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World!');
END;
/
在SQLPLUS下面运行
SQL> exec proaaa;
Hello World!
PL/SQL procedure successfully completed
例2
CREATE OR REPLACE PROCEDURE ddd(param1 IN VARCHAR2)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('HELLO' || param1);
END;
/
运行
SQL> exec ddd('aaa');
HELLOaaa
PL/SQL procedure successfully completed
例3
CREATE OR REPLACE PROCEDURE outPara(outParam1 OUT VARCHAR2)
IS
BEGIN
outParam1 := 'Hello OUT parameter';
END;
/
运行
DECLARE
outParam1 VARCHAR2(100);
BEGIN
outPara(outParam1);
DBMS_OUTPUT.PUT_LINE(outParam1);
END;
/