CREATE OR REPLACE PROCEDURE PRO_PROJ_REPORT_CRM_FINAN(V_P_PROJID IN NUMBER, V_P_CUSID IN NUMBER, V_E_MESSAGE OUT VARCHAR2, V_RESULTFLAG OUT VARCHAR2) IS ...
oracle循环调用存储过程案例
标签：div 存储过程 end date test har int select tom
oracle循环调用存储过程案例
;
out1 varchar2(100);
out2 varchar2(100);
CUSTOMERID NUMBER;
cursor projidlist is select p.projid from proj_baseinfo p where p.projstage!=‘-999‘;
begin
for i in projidlist LOOP
begin
select p.customerid into CUSTOMERID from proj_baseinfo p where p.projid=i.projid;
dbms_output.put_line(CUSTOMERID);
PRO_PROJ_REPORT_CRM_FINAN(i.projid,CUSTOMERID,out1,out2); end;
end LOOP;
commit;
end testdate_2;