oracle存储过程

例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;
/