The CREATE OR REPLACE PROCEDURE PRC_REPORT_R0001 (V_RECORD out TYPE_RECORD) IS
- define a 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;


The BEGIN

- business logic

END PRC_REPORT_R0001;


I define RECORD is I want to return the result set, how to return?
PROCEDURE SCM170831. PRC_REPORT_R0001 compiler error

Error: PLS - 00201: the identifier 'TYPE_RECORD' must be declared
Line: 1
Text: CREATE OR REPLACE PROCEDURE PRC_REPORT_R0001 (V_RECORD out TYPE_RECORD) IS

CodePudding user response:

You try to define outside defined first try type

CodePudding user response:

 & lt; p> TYPE TYPE_RECORD IS TABLE OF & lt; Del> Types. & lt;/del> TEMP_RECORD; 

CodePudding user response:

refer to the second floor weixin_38847048 response:

& lt;/p>

 & lt; p> TYPE TYPE_RECORD IS TABLE OF & lt; Del> Types. & lt;/del> TEMP_RECORD; 

TYPE TYPE_RECORD IS TABLE OF TEMP_RECORD;

CodePudding user response:

reference 1st floor baidu_36457652 response:

you try good definition to define the type outside try

outside the interview also not line,,,

CodePudding user response:

Or returns sys_cursor type a try?