oracle中,视图好像不能传参数进去.
我试着写存储过程
create or replace procedure test(@userid varchar) is
begin
select * from users where UserID=@userid;
end test;
也行不通.大虾们,帮下忙.
我试着写存储过程
create or replace procedure test(@userid varchar) is
begin
select * from users where UserID=@userid;
end test;
也行不通.大虾们,帮下忙.
begin
select * from users where UserID=userid;
end test;
select * from T1 where UserID=userid;
begin
delete from T2;
for rec in c loop
insert into T2 values rec;
end loop;
commit;
end test;试试这个.先建个和T1机构一样的表T2,然后每次调用时,把要的数据填进去.这里没加Exception的处理.