| 小白一枚，我写了一个存储过程 ，但是执行的时候 却查询不到数据 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); |
