create or replace procedure t_query(
v_dno in drug.dno%type,
v_name out drug.dname%type,
v_class out drug.dclass%type,
v_spec out drug.dspec%type,
v_brand out drug.dbrand%type,
v_price1 out drug.dprice1%type,
v_price2 out drug.dprice2%type
)
is
begin
select dname,dclass,dspec,dbrand,dprice1,dprice2 into
v_name,v_class,v_spec,v_brand,v_price1,v_price2 from drug
where dno=v_dno;
end t_query;
drop procedure t_query;
执行后出现以下错误:
没找出问题
求大佬解答