oracle简单存储过程（带参数）

1、新建一个存储过程

 

create or replace procedure Test_getTast(in_id    in VARCHAR2,
                                       out_name out VARCHAR2
                                       )
is
begin
  select title into out_name
  from  assignment t
  where task_id = in_id;
exception
when NO_DATA_FOUND then dbms_output.put_line('exception');
end Test_getTast;

2、新建一个测试窗口

-- Created on 12-12-7 by ADMINISTRATOR 
declare 
  -- Local variables here
  i varchar2(7);
  j varchar2(8000);
begin
  i := '25978';
  dbms_output.put_line(i);
  Test_getTast(i,j);
  dbms_output.put_line(j);
end;