create package test_age as type myrc is ref cursor; end; / create or replace procedure pro_login (name in cj.tb_operator.oper_code%type,pass in cj.tb_operator.password%type,p_rc out test_age.myrc) as begin open p_rc for 'select a.oper_code,a.oper_name,a.password,b.dep_name,a.oper_grant,a.telephone from tb_operator a,tb_department b where a.dep_id=b.dep_idand and a.oper_code='||name||' and a.password='||pass; end; /
to beckhambobo(beckham) 能说说在java里怎么调用吗? 我试了半天不行呀? 说完旧结帐!
as
type myrc is ref cursor;
end;
/
create or replace procedure pro_login
(name in cj.tb_operator.oper_code%type,pass in cj.tb_operator.password%type,p_rc out test_age.myrc)
as
begin
open p_rc for 'select a.oper_code,a.oper_name,a.password,b.dep_name,a.oper_grant,a.telephone
from tb_operator a,tb_department b where a.dep_id=b.dep_idand and a.oper_code='||name||' and a.password='||pass;
end;
/
能说说在java里怎么调用吗?
我试了半天不行呀?
说完旧结帐!