存储过程如下
怎么调用呢
我的意思是我不知道返回几个字段的内容时在程序里怎么写CREATE OR REPLACE PROCEDURE WAREHOUSE_INKCOUNT_2(
Stime IN DATE DEFAULT NULL,
Etime IN DATE DEFAULT NULL,
SortId IN NUMBER DEFAULT NULL,
RC1 IN OUT Omwb_emulation.globalPkg.RCT1)
AS
Stime_ DATE := Stime;
Etime_ DATE := Etime;
SortId_ NUMBER(3,0) := SortId;
StoO_selcnt INTEGER;
StoO_error INTEGER;
StoO_rowcnt INTEGER;
StoO_crowcnt INTEGER := 0;
StoO_fetchstatus INTEGER := 0;
StoO_errmsg VARCHAR2(255);
StoO_sqlstatus INTEGER;
BEGIN
OPEN RC1 FOR
SELECT sort_coding
, name
, standard
, SUM(number_)
, price_rk
, SUM(price_rk * number_)
, kfname
, intime
FROM storage_instoreview ;
END WAREHOUSE_INKCOUNT_2;
怎么调用呢
我的意思是我不知道返回几个字段的内容时在程序里怎么写CREATE OR REPLACE PROCEDURE WAREHOUSE_INKCOUNT_2(
Stime IN DATE DEFAULT NULL,
Etime IN DATE DEFAULT NULL,
SortId IN NUMBER DEFAULT NULL,
RC1 IN OUT Omwb_emulation.globalPkg.RCT1)
AS
Stime_ DATE := Stime;
Etime_ DATE := Etime;
SortId_ NUMBER(3,0) := SortId;
StoO_selcnt INTEGER;
StoO_error INTEGER;
StoO_rowcnt INTEGER;
StoO_crowcnt INTEGER := 0;
StoO_fetchstatus INTEGER := 0;
StoO_errmsg VARCHAR2(255);
StoO_sqlstatus INTEGER;
BEGIN
OPEN RC1 FOR
SELECT sort_coding
, name
, standard
, SUM(number_)
, price_rk
, SUM(price_rk * number_)
, kfname
, intime
FROM storage_instoreview ;
END WAREHOUSE_INKCOUNT_2;
在过程中返回游标 my_cr
open my_cr for select * from you_table where 1,2,3,4,...