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
The begin
The 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;
The following error appears after the execution:
Didn't find out problems
For big solutions
CodePudding user response:
end t_query;Drop procedure t_query;
Between these two lines, plus a/
End t_query;
Drop procedure t_query;