存储过程写法如下:
create or replace procedure Pr_d2_delCar(
d2_cpkid in d2_car.cpkid%type
)
as
begin
delete from D2_HC t where fkpkid in (d2_cpkid) and hctype='2'; delete from D2_KYRETURNCONTENT t where kypkid in (select kypkid from D2_KY t where fkpkid in (d2_cpkid) and kytype='2'); delete from D2_MONITOR t where ppkid in (d2_cpkid) and zt='2'; delete from D2_PASSCAREXT t where cpkid in (d2_cpkid); delete from D2_KY t where fkpkid in (d2_cpkid) and kytype='2'; delete from D2_CAR t where cpkid in (d2_cpkid);
end;
调用如下:
DECLARE
num1 number := 181,182;
BEGIN
Pr_d2_delCar(num1);
END;
如果181,182.只传入一个参数,是没问题的,现在我想请问高手,怎么把181,182作为一个参数传进去
create or replace procedure Pr_d2_delCar(
d2_cpkid in d2_car.cpkid%type
)
as
begin
delete from D2_HC t where fkpkid in (d2_cpkid) and hctype='2'; delete from D2_KYRETURNCONTENT t where kypkid in (select kypkid from D2_KY t where fkpkid in (d2_cpkid) and kytype='2'); delete from D2_MONITOR t where ppkid in (d2_cpkid) and zt='2'; delete from D2_PASSCAREXT t where cpkid in (d2_cpkid); delete from D2_KY t where fkpkid in (d2_cpkid) and kytype='2'; delete from D2_CAR t where cpkid in (d2_cpkid);
end;
调用如下:
DECLARE
num1 number := 181,182;
BEGIN
Pr_d2_delCar(num1);
END;
如果181,182.只传入一个参数,是没问题的,现在我想请问高手,怎么把181,182作为一个参数传进去
解决方案 »
- 下面的一个归类题,一时想不通,求大虾!
- 关于oracle查询问题................高人啊~~~~~~~
- ORA-27046: file size is not a multiple of logical block size急救!在线等
- dbms_output.put_line(time_after - time_before)结果怎么是0?
- 一条SQL语句的优化
- oracle DBA是蓝领还是白领啊?
- 在oracle9i的OEM下创建作业出错,错误提示ora-00972:identifier is too long,请各位大虾解释解释是什么原因
- [求助]数据库导入时遇到的问题,急
- 请教VPN连接ORACLE时,ORACLE服务器端要为客户端开发什么端口呢?
- 当对表插入一条新数据时,通过触发器,同时将该条数据插入到另外一张表中如何处理,高手指点
- 急急急!求解
- oracle存储过程字段用变量如何赋值
你可以
BEGIN
Pr_d2_delCar(181);
Pr_d2_delCar(182);
END;
d2_cpkid in d2_car.cpkid%type
可以把它改为一个数组