存储过程1
create or replace procedure pro_select(
input_productid in CHAR,
output_productname out VARCHAR2,
output_price out number,
output_REALPRODUCTNO out VARCHAR2,
output_REALPRODUCTNO2 out VARCHAR2) isbegin select productname,price,REALPRODUCTNO,REALPRODUCTNO2 into output_productname,output_price,output_REALPRODUCTNO,output_REALPRODUCTNO2
from product where productid=input_productid;
end pro_select;存储过程2create or replace procedure pro_delete(input_city in VARCHAR2) is
begin
delete from city where city=input_city;
end pro_delete;不考虑任何逻辑关系
我就是想让存储过程1运行最后在运行存储过程2
哪位告诉我多谢!
create or replace procedure pro_select(
input_productid in CHAR,
output_productname out VARCHAR2,
output_price out number,
output_REALPRODUCTNO out VARCHAR2,
output_REALPRODUCTNO2 out VARCHAR2) isbegin select productname,price,REALPRODUCTNO,REALPRODUCTNO2 into output_productname,output_price,output_REALPRODUCTNO,output_REALPRODUCTNO2
from product where productid=input_productid;
end pro_select;存储过程2create or replace procedure pro_delete(input_city in VARCHAR2) is
begin
delete from city where city=input_city;
end pro_delete;不考虑任何逻辑关系
我就是想让存储过程1运行最后在运行存储过程2
哪位告诉我多谢!
pro_select(..参数..);
pro_delete(..参数..);
end;
你的过程2的参数要是来源过程1,就把input_city换成过程1中对应的值就可以了
create or replace procedure pro_select(
input_productid in CHAR,
output_productname out VARCHAR2,
output_price out number,
output_REALPRODUCTNO out VARCHAR2,
output_REALPRODUCTNO2 out VARCHAR2) is
begin select productname,price,REALPRODUCTNO,REALPRODUCTNO2 into output_productname,output_price,output_REALPRODUCTNO,output_REALPRODUCTNO2
from product where productid=input_productid;
end pro_select;
begin
delete from city where city=input_city;
end pro_delete;
楼主可以试一下先,我都是这么用的,有问题再拿出来一下商量……
procedure pro_select(
input_productid in CHAR,
output_productname out VARCHAR2,
output_price out number,
output_REALPRODUCTNO out VARCHAR2,
output_REALPRODUCTNO2 out VARCHAR2) is
begin select productname,price,REALPRODUCTNO,REALPRODUCTNO2 into output_productname,output_price,output_REALPRODUCTNO,output_REALPRODUCTNO2
from product where productid=input_productid;
end pro_select;
begin
delete from city where city=input_city;
end pro_delete;