create or replace procedure procedure_hello_test
AS
    str VARCHAR(50);
begin
    str:=‘hello world‘;
    dbms_output.put_line ( ‘str = ‘ || str );
end;
begin
    procedure_hello_test();
end;

drop procedure procedure_hello_test;

参考自：https://www.cnblogs.com/joeyJss/p/11458653.html

Oracle一个简单的存储过程