CREATE OR REPLACE PROCEDURE PRC_REPORT_R0001(V_RECORD out TYPE_RECORD) IS
--定义一个RECORD
TYPE TEMP_RECORD IS RECORD(
GROUP_ID NUMBER,
GROUP_NAME VARCHAR2(200),
ENGINEER_ID NUMBER,
ENGINEER_NAME VARCHAR2(200),
SUPPLIER_OPEN_COUNT NUMBER,
SUPPLIER_OPEN_AMT NUMBER,
DEPT_OPEN_COUNT NUMBER,
DEPT_OPEN_AMT NUMBER,
SUM_OPEN_COUNT NUMBER,
SUM_OPEN_AMT NUMBER); TYPE TYPE_RECORD IS TABLE OF types.TEMP_RECORD;
V_RECORD TYPE_RECORD;
BEGIN
--业务逻辑
END PRC_REPORT_R0001;
我定义的RECORD 就是我要返回的结果集,怎么返回呢?
PROCEDURE SCM170831.PRC_REPORT_R0001 编译错误错误:PLS-00201: identifier 'TYPE_RECORD' must be declared
行:1
文本:CREATE OR REPLACE PROCEDURE PRC_REPORT_R0001(V_RECORD out TYPE_RECORD) IS
--定义一个RECORD
TYPE TEMP_RECORD IS RECORD(
GROUP_ID NUMBER,
GROUP_NAME VARCHAR2(200),
ENGINEER_ID NUMBER,
ENGINEER_NAME VARCHAR2(200),
SUPPLIER_OPEN_COUNT NUMBER,
SUPPLIER_OPEN_AMT NUMBER,
DEPT_OPEN_COUNT NUMBER,
DEPT_OPEN_AMT NUMBER,
SUM_OPEN_COUNT NUMBER,
SUM_OPEN_AMT NUMBER); TYPE TYPE_RECORD IS TABLE OF types.TEMP_RECORD;
V_RECORD TYPE_RECORD;
BEGIN
--业务逻辑
END PRC_REPORT_R0001;
我定义的RECORD 就是我要返回的结果集,怎么返回呢?
PROCEDURE SCM170831.PRC_REPORT_R0001 编译错误错误:PLS-00201: identifier 'TYPE_RECORD' must be declared
行:1
文本:CREATE OR REPLACE PROCEDURE PRC_REPORT_R0001(V_RECORD out TYPE_RECORD) IS
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货