源代碼如下：
CREATE OR REPLACE Procedure sRptRPT10020000002723
(SysOrgCode In VarChar2,
SysUserId In Number,
SysUserCode In VarChar2,
SysUserName In VarChar2,
UParamvs_BgnDate in Date,
UParamvs_EndDate in Date,
Result_Set Out pxt_db.cCurType )
Is
vs_BgnDate varchar2(10); --------定義開始日期
vs_EndDate varchar2(10); --------定義結束日期
vs_YYYYMM varchar2(6); --------定義表格變數
vs_sql varchar2(8000); --------定義字符
-------------------------------------定義變數
begin
vs_BgnDate:=to_char(vs_BgnDate,'YYYY-MM-DD');
vs_EndDate:=to_char(vs_EndDate,'YYYY-MM-DD');
vs_YYYYMM:=substr(vs_BgnDate,1,4)||substr(vs_EndDate,6,2);
if pxt_db.Exist_Object(upper('tSalPluDetail'||vs_YYYYMM),'synonym' ,'') then
vs_sql:='SELECT depcode,depname,plucode,pluname,
sum(xscount) as xscount,
sum(price) as price,
sum(fsprice) as fsprice,
sum(HXTotal) as hxtotal,
sum(CxTotal) as cxtotal,
sum(hmtotal) as hmtotal,
ROUND( (hmtotal/hxtotal)*100,2) as mltotal
FROM tSalPluDetail||vs_YYYYMM)
WHERE rptdate BETWEEN '''||vs_BgnDate||''' and '''||vs_EndDate||'''
group by depcode, depname, plucode, pluname,
ROUND( (hmtotal/hxtotal)*100,2)';
end if;
open result_set for (vs_sql);
end sRptRPT10020000002723;
查詢錯誤提示：
這個問題怎么解決
uj5u.com熱心網友回復：
open result_set for (vs_sql);你這句寫在 if 外面，vs_sql沒有賦到值，那不就是長度0了。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/14716.html
標籤：基礎和管理