c#中调用oracle数据库的高手进(100分,咨询函数调用问题)
现定义函数CS_CSJS_ZZ如下,在函数体中有一返回值return 1,不用看具体函数的意义,我现在就是先确定一下,调用函数都会有一个返回值,但是在该函数中return模块中变量较多,而最终只返回一个1,我该如何定义一个变量来获取这个return值
CREATE OR REPLACE FUNCTION CS_CSJS_ZZ
(an_zt_hh IN NUMBER,
an_kjnd IN NUMBER,
an_qsqj IN NUMBER,
an_jsqj IN NUMBER,
an_czyh_hh IN NUMBER
)
RETURN NUMBER IS
lvc_cwhdm VARCHAR2(32);
ln_kjzd_hh number(20);
ln_bwb_hh number(20);
li_qjjsq INTEGER;
CURSOR lc_kjkm IS
SELECT KJKM_HH FROM V_ZZ_ZTKM WHERE JL_SC_BZ = '0 ' AND KJND = an_kjnd AND ZT_HH = an_zt_hh ORDER BY kjkmdm;
lt_kjkm number(20);
ln_lsjl_hh number(20);
ln_qyqj number(10);
ln_sykjqj number(10);
ln_qynd number(4);
ln_nmqj number(10);
ln_ncqj number(10);