The CREATE TYPE PERSON IS varrays (4) OF VARCHAR2 (30);


The CREATE TYPE PERSON_ARRAY IS varrays (4) OF the PERSON;


The CREATE OR REPLACE PACKAGE BODY TEST
AS

The FUNCTION MAIN (BODY1 IN VARCHAR2,
BODY2 IN VARCHAR2,
BODY3 IN VARCHAR2)
RETURN PERSON_ARRAY
IS
The BEGIN
RETURN PERSON_ARRAY (PERSON (BODY1, BODY1, BODY1, to_char (sysdate)), the PERSON (BODY2 BODY2, to_char (sysdate), BODY2), PERSON (BODY3, to_char (sysdate), BODY3, BODY3), PERSON (to_char (sysdate), BODY1, BODY1, BODY1));
END the MAIN;
END the TEST.


Implement an error after

CodePudding user response:

 
- the original poster is not defined in baotou, or some questions from baotou 
- this is your code, I altered the simple, you consider, there is a problem can I @ 

SQL> The CREATE TYPE PERSON IS varrays (4) OF VARCHAR2 (30); 
2/
Type created 
SQL> The CREATE TYPE PERSON_ARRAY IS varrays (4) OF the PERSON; 
2/
Type created 
SQL> The CREATE OR REPLACE PACKAGE TEST 
2 AS 
3 the FUNCTION MAIN (BODY1 IN VARCHAR2, 
4 BODY2 IN VARCHAR2, 
5 BODY3 IN VARCHAR2) 
6 RETURN PERSON_ARRAY; 
7 the END TEST; 
8/
Package created 
SQL> The CREATE OR REPLACE PACKAGE BODY TEST 
2 AS 
3 the FUNCTION MAIN (BODY1 IN VARCHAR2, 
4 BODY2 IN VARCHAR2, 
5 BODY3 IN VARCHAR2) 
6 RETURN PERSON_ARRAY 
7 IS 
8 the BEGIN 
9 the RETURN PERSON_ARRAY (
10 PERSON (BODY1, BODY1, BODY1, to_char (sysdate)), 
11 PERSON (BODY2 BODY2, to_char (sysdate), BODY2), 
12 PERSON (BODY3, to_char (sysdate), BODY3, BODY3), 
13 PERSON (to_char (sysdate), BODY1, BODY1, BODY1) 
14); 
15 the END the MAIN; 
The END of 16 TEST; 
17/
Package body created 
SQL> Select the test. The main (1, 2, 3) from dual; 
TEST. The MAIN (1, 2, 3) 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --