存储过程返回数组对象例子源码介绍,其实就相当于返回List里面放的对象数据,定义如下:
1.创建存储过程对象
CREATE OR REPLACE TYPE “T_ACCOUNT_MONTH”
as object(
ACCOUNT_ID NUMBER,
INIT_AMOUNT NUMBER,
DEBIT_AMOUNT NUMBER,
CREDIT_AMOUNT NUMBER
)
2.创建存数过程数组
CREATE OR REPLACE TYPE “T_ACCOUNT_MONTH_TABLE”
as table of t_account_month[......]