小白一枚,我写了一个存储过程 ,但是执行的时候 却查询不到数据
create table text
(
sid number not null primary key,
sname varchar(10),
school varchar(10)
)
create or replace procedure proc_select
(
s_sid in number
)
is
s_sname varchar2;
s_school varchar2;
begin
select sname,school into s_sname,s_school from text where sid=s_sid;
end;
insert into text values(1,'xx','scs');
call proc_select(1);