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;
執行后出現以下錯誤：
沒找出問題
求大佬解答
uj5u.com熱心網友回復：
end t_query;drop procedure t_query;
這兩行中間，加一個 /
end t_query;
/
drop procedure t_query;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/43234.html
標籤：開發