1.没有参数的存储过程

create or replace procedure get_time
as
   cur_time varchar2(10);
begin
  select to_char(sysdate,'yyyymmdd') into cur_time from dual;
  dbms_output.put_line(cur_time);
end;

call get_time();

2.有输出参数的存储过程
create or replace procedure get_time(cur_time out varchar2)
as
begin
  select to_char(sysdate,'yyyymmdd') into cur_time from dual;
end;

declare
  cur_time varchar2(10);
begin
  get_time(cur_time);
  dbms_output.put_line(cur_time);
end;