oracle存储过程实例带参数 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;