--创建存储过程
create or replace procedure getdateas datetime varchar2(100);begin  select to_char(sysdate,‘yyyy-mm-dd hh24:mi:ss‘) into datetime from dual;  dbms_output.put_line(‘当前时间为：‘||datetime);end;

--调用存储过程
begin 
  getdate;
end；

--创建存储过程
create or replace procedure getnetworkid(familyid in varchar2)as networkid varchar2(100);begin   select f.cnetworkid into temp from Vav_Radio_Family f  where f.cfamilyid=familyid;  dbms_output.put_line(‘地区：‘||networkid);end;

--调用存储过程begingetnetworkid(420530145);end;

--创建存储过程
create or replace procedure out_date(datetime out varchar2)as beginselect count(*) into datetime from dual;  dbms_output.put_line(‘当前时间为：‘||datetime);end;
--调用存储过程declare datetime varchar2(100);begin  out_date(datetime);end;