我们知道,SQLServer无论是函数还是存储过程,其返回结果集都是较为简单的,在这里我们就不多加说明了,下面我们将通过实例详细分析一下Oracle的函数和存储过程返回结果集的方法:
1、函数
首先创建某一个对象类型如下:
CREATE OR REPLACE TYPE "NS_FB_BUSINESS_SPECIALVAL_ROW" AS OBJECT
(
BID INTEGER,
BIZ_TYPE VARCHAR2(4),
CONTRACT_NO VARCHAR2(32),
DEBTOR INTEGER,
CURRENCY_NO VARCHAR2(4),
START_DATE DATE,
MATURITY DATE,
STATE INTEGER,
SUB_STATE INTEGER,
SPEVAL NUMBER(15,2),
special_list_id INTEGER,
ledger_type VARCHAR2(4),
loanTerm VARCHAR(64),
LOANTERMNAME VARCHAR(256),
CORPNO VARCHAR2(32),
CORPNAME VARCHAR2(100),
CRGRADE VARCHAR2(32),
self_support INTEGER
)
然后,创建一表类型如下:
CREATE OR REPLACE TYPE "NS_FB_BUSINESS_SPECIALVAL_TAB" AS TABLE OF NS_FB_BUSINESS_SPECIALVAL_ROW
紧接着我们要创建一函数如下:
CREATE OR REPLACE FUNCTION NS_FB_BUSINESS_SPECIAL_VAL(pDate_ IN DATE DEFAULT NU