Oracle和SQLServer分别使用函数和存储过程返回结果集

我们知道，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