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;执行后出现以下错误:没找出问题求大佬解答
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;执行后出现以下错误:没找出问题求大佬解答
drop procedure t_query;
这两行中间,加一个 / end t_query;
/
drop procedure t_query;