PL/SQL学习笔记-过程

create or replace procedure xland_proc
(v_title in varchar2,v_int out number)
is
v_char varchar2(111);
begin
select labor.xland.state,title into v_int,v_char from labor.xland where title = v_title;
end xland_proc;

declare
x number;
begin
xland_proc('xland',x);
dbms_output.put_line(to_char(x));
end;

drop procedure xland_proc;