Oracle Live SQL - Script: complex type

Statement 1

create or replace type redd_rtTotali is object ( 
        "PROD_C" CHAR(11), 
        "CONTR_N" CHAR(20), 
        "PROD_C_FONDO" CHAR(11), 
        "CONTR_N_POLIZ" CHAR(11),  
        "DT_INIZIO" date, 
        "DT_FINE" date, 
        "IMP_CAPIT_VERS" NUMBER(18,3), 
        "IMP_CAPIT_REINV" NUMBER(18,3), 
        "IMP_CAPIT_INVEST" NUMBER(18,3), 
        "IMP_RIMBO_CONTO_CORR" NUMBER(18,3), 
        "IMP_RIMBO_REINV" NUMBER(18,3), 
        "IMP_PROVENTI_DISTR" NUMBER(18,3), 
        "IMP_DECUMU" NUMBER(18,3), 
    MEMBER FUNCTION get_key RETURN varchar2 
);

Type created.

Statement 2

CREATE OR REPLACE TYPE BODY redd_rtTotali AS 
  MEMBER FUNCTION get_key RETURN varchar2 IS 
  BEGIN 
    RETURN trim(PROD_C)||'-'||trim(CONTR_N)||'-'||trim(CONTR_N_POLIZ)||'-'||trim(PROD_C_FONDO); 
  END; 
END;

Type created.

Statement 3

create or replace type redd_rtPatrim is object ( 
	"PROD_C" CHAR(11),  
	"CONTR_N" CHAR(20),  
	"PROD_C_FONDO" CHAR(11), 
	"CONTROVALORE" NUMBER(18,3), 
	"QTA_QUOTE" NUMBER(18,3), 
	"CONTR_N_POLIZ" CHAR(11), 
    MEMBER FUNCTION get_key RETURN varchar2 
);

Type created.

Statement 4

CREATE OR REPLACE TYPE BODY redd_rtPatrim AS 
  MEMBER FUNCTION get_key RETURN varchar2 IS 
  BEGIN 
    RETURN trim(PROD_C)||'-'||trim(CONTR_N)||'-'||trim(CONTR_N_POLIZ)||'-'||trim(PROD_C_FONDO); 
  END; 
END;

Type created.

Statement 5

create type redd_tbInput IS TABLE OF redd_rtInput;

Error at line 0: PL/SQL: Compilation unit analysis terminated

Statement 6

drop type "REDD_TBINPUT"

Type dropped.

Statement 7

create type redd_tbPatrim as table of redd_rtPatrim

Type created.

Statement 8

create type redd_tbTotali as table of redd_rtTotali

Type created.

Statement 9

select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual


REDD_RTTOTALI('A','B','C','D',CURRENT_DATE,CURRENT_DATE,1,2,3,4,5,6,7)
[unsupported data type]

REDD_RTTOTALI('A','B','C','D',CURRENT_DATE,CURRENT_DATE,1,2,3,4,5,6,7)
[unsupported data type]

Statement 10

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    LOOP
        FETCH v1 
            BULK COLLECT INTO table1;

        FOR indx IN 1 .. table1.COUNT 
        LOOP
            dbms_output.put_line(table1(indx).get_key());
        END LOOP;

        EXIT WHEN table1.COUNT < limit_in;

   END LOOP;


end;

ORA-06550: line 20, column 34:
PLS-00201: identifier 'LIMIT_IN' must be declared
ORA-06550: line 20, column 9:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 11

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1 limit 0;

    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


end;

ORA-06502: PL/SQL: numeric or value error

Statement 12

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1 limit 0;




end;

ORA-06502: PL/SQL: numeric or value error

Statement 13

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;


    close v1;

end;

Statement processed.

Statement 14

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    close v1;

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c

Statement 15

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c

Statement 16

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;
    
    FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 29, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 17

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;
    
    FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 29, column 5:
PL/SQL: Statement ignored
ORA-06550: line 34, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 34, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 18

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;
    
    FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 29, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 19

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 20

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table2 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 19, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 18, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 26, column 27:
PLS-00371: at most one declaration for 'TABLE2' is permitted
ORA-06550: line 25, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 31, column 22:
PLS-00371: at most one declaration for 'TABLE2' is permitted
ORA-06550: line 31, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 21

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c

Statement 22

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c

Statement 23

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c

Statement 24

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 25

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select * from
table(c1) a1,
table(c2) a2;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 26

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select * from
table(c1) a1,
table(c2) a2
where
    a1.get_key()=a2.get_key();
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 27

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    * 
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 28

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 29

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    open v3(table1, table2);
        fetch v3 into crec;
     EXIT WHEN v3%NOTFOUND;
        dbms_output.put_line(crec.prod_c);
    close v3;

end;

ORA-06550: line 56, column 6:
PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-06550: line 56, column 6:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 30

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 31

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    open v3(table1, table2);
        fetch v3 into crec;
     EXIT WHEN v3%NOTFOUND;
     
        dbms_output.put_line(crec.prod_c);
        
    close v3;

end;

ORA-06550: line 56, column 6:
PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-06550: line 56, column 6:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 32

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    open v3(table1, table2);
        fetch v3 into crec;
     EXIT WHEN v3%NOTFOUND;
     
        dbms_output.put_line(crec.prod_c);
        
    close v3;

end;

ORA-06550: line 56, column 6:
PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-06550: line 56, column 6:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 33

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    open v3(table1, table2);
        fetch v3 into crec;
     EXIT WHEN v3%NOTFOUND;
     
        dbms_output.put_line(crec.prod_c);
        
    close v3;

end;

ORA-06550: line 56, column 6:
PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-06550: line 56, column 6:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 34

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 35

create or replace type cll.redd_rtTotali is object ( 
        "PROD_C" CHAR(11), 
        "CONTR_N" CHAR(20), 
        "PROD_C_FONDO" CHAR(11), 
        "CONTR_N_POLIZ" CHAR(11),  
        "DT_INIZIO" date, 
        "DT_FINE" date, 
        "IMP_CAPIT_VERS" NUMBER(18,3), 
        "IMP_CAPIT_REINV" NUMBER(18,3), 
        "IMP_CAPIT_INVEST" NUMBER(18,3), 
        "IMP_RIMBO_CONTO_CORR" NUMBER(18,3), 
        "IMP_RIMBO_REINV" NUMBER(18,3), 
        "IMP_PROVENTI_DISTR" NUMBER(18,3), 
        "IMP_DECUMU" NUMBER(18,3), 
    MEMBER FUNCTION get_key RETURN varchar2 
);

ORA-01031: insufficient privileges

More Details: https://docs.oracle.com/error-help/db/ora-01031

Statement 36

CREATE OR REPLACE TYPE BODY CLL.redd_rtTotali AS 
  MEMBER FUNCTION get_key RETURN varchar2 IS 
  BEGIN 
    RETURN trim(PROD_C)||'-'||trim(CONTR_N)||'-'||trim(CONTR_N_POLIZ)||'-'||trim(PROD_C_FONDO); 
  END; 
END;

ORA-01031: insufficient privileges

More Details: https://docs.oracle.com/error-help/db/ora-01031

Statement 37

create or replace type redd_rtTotali is object ( 
        "PROD_C" CHAR(11), 
        "CONTR_N" CHAR(20), 
        "PROD_C_FONDO" CHAR(11), 
        "CONTR_N_POLIZ" CHAR(11),  
        "DT_INIZIO" date, 
        "DT_FINE" date, 
        "IMP_CAPIT_VERS" NUMBER(18,3), 
        "IMP_CAPIT_REINV" NUMBER(18,3), 
        "IMP_CAPIT_INVEST" NUMBER(18,3), 
        "IMP_RIMBO_CONTO_CORR" NUMBER(18,3), 
        "IMP_RIMBO_REINV" NUMBER(18,3), 
        "IMP_PROVENTI_DISTR" NUMBER(18,3), 
        "IMP_DECUMU" NUMBER(18,3), 
    MEMBER FUNCTION get_key RETURN varchar2 
);

ORA-02303: cannot drop or replace a type with type or table dependents

More Details: https://docs.oracle.com/error-help/db/ora-02303

Statement 38

CREATE OR REPLACE TYPE BODY redd_rtTotali AS 
  MEMBER FUNCTION get_key RETURN varchar2 IS 
  BEGIN 
    RETURN trim(PROD_C)||'-'||trim(CONTR_N)||'-'||trim(CONTR_N_POLIZ)||'-'||trim(PROD_C_FONDO); 
  END; 
END;

Type created.

Statement 39

create or replace type redd_rtPatrim is object ( 
	"PROD_C" CHAR(11),  
	"CONTR_N" CHAR(20),  
	"PROD_C_FONDO" CHAR(11), 
	"CONTROVALORE" NUMBER(18,3), 
	"QTA_QUOTE" NUMBER(18,3), 
	"CONTR_N_POLIZ" CHAR(11), 
    MEMBER FUNCTION get_key RETURN varchar2 
);

ORA-02303: cannot drop or replace a type with type or table dependents

More Details: https://docs.oracle.com/error-help/db/ora-02303

Statement 40

CREATE OR REPLACE TYPE BODY redd_rtPatrim AS 
  MEMBER FUNCTION get_key RETURN varchar2 IS 
  BEGIN 
    RETURN trim(PROD_C)||'-'||trim(CONTR_N)||'-'||trim(CONTR_N_POLIZ)||'-'||trim(PROD_C_FONDO); 
  END; 
END;

Type created.

Statement 41

create type redd_tbInput IS TABLE OF redd_rtInput;

Error at line 0: PL/SQL: Compilation unit analysis terminated

Statement 42

drop type "REDD_TBINPUT"

Type dropped.

Statement 43

create type redd_tbPatrim as table of redd_rtPatrim

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 44

create type redd_tbTotali as table of redd_rtTotali

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 45

select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual


REDD_RTTOTALI('A','B','C','D',CURRENT_DATE,CURRENT_DATE,1,2,3,4,5,6,7)
[unsupported data type]

REDD_RTTOTALI('A','B','C','D',CURRENT_DATE,CURRENT_DATE,1,2,3,4,5,6,7)
[unsupported data type]

Statement 46

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    LOOP
        FETCH v1 
            BULK COLLECT INTO table1;

        FOR indx IN 1 .. table1.COUNT 
        LOOP
            dbms_output.put_line(table1(indx).get_key());
        END LOOP;

        EXIT WHEN table1.COUNT < limit_in;

   END LOOP;


end

ORA-06550: line 25, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   ; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 47

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    LOOP
        FETCH v1 
            BULK COLLECT INTO table1;

        FOR indx IN 1 .. table1.COUNT 
        LOOP
            dbms_output.put_line(table1(indx).get_key());
        END LOOP;

        EXIT WHEN table1.COUNT < limit_in;

   END LOOP;


end;

ORA-06550: line 20, column 34:
PLS-00201: identifier 'LIMIT_IN' must be declared
ORA-06550: line 20, column 9:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 48

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    LOOP
        FETCH v1 
            BULK COLLECT INTO table1 limit 0;

        FOR indx IN 1 .. table1.COUNT 
        LOOP
            dbms_output.put_line(table1(indx).get_key());
        END LOOP;

        EXIT WHEN table1.COUNT < limit_in;

   END LOOP;


end;

ORA-06550: line 20, column 34:
PLS-00201: identifier 'LIMIT_IN' must be declared
ORA-06550: line 20, column 9:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 49

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1 limit 0;

    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


end;

ORA-06502: PL/SQL: numeric or value error

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 50

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1 limit 0;




end;

ORA-06502: PL/SQL: numeric or value error

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 51

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;


    close v1;

end;

Statement processed.

Statement 52

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    close v1;

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c

Statement 53

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c

Statement 54

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;
    
    FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 29, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 55

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;
    
    FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 29, column 5:
PL/SQL: Statement ignored
ORA-06550: line 34, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 34, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 56

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;
    
    FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;
        
    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;

    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 22:
PLS-00201: identifier 'TABLE1.COUNT' must be declared
ORA-06550: line 29, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 57

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 18, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 17, column 5:
PL/SQL: SQL Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 58

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table2 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

ORA-06550: line 19, column 27:
PLS-00201: identifier 'TABLE1' must be declared
ORA-06550: line 18, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 26, column 27:
PLS-00371: at most one declaration for 'TABLE2' is permitted
ORA-06550: line 25, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 31, column 22:
PLS-00371: at most one declaration for 'TABLE2' is permitted
ORA-06550: line 31, column 5:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 59

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c

Statement 60

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c

Statement 61

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('a','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c
a-b-d-c

Statement 62

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;


end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 63

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select * from
table(c1) a1,
table(c2) a2;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 64

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select * from
table(c1) a1,
table(c2) a2
where
    a1.get_key()=a2.get_key();
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 65

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    * 
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 66

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    

end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c

Statement 67

declare cursor v1 is
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual;
table1 redd_tbTotali;
cursor v2 is
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all
select redd_rtPatrim('e','b','c',1,2,'d') from dual ;
table2 redd_tbPatrim;
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is
select
    a1.prod_c,
    a1.contr_n,
    a1.IMP_CAPIT_VERS,
    a2.controvalore
from
    table(c1) a1,
    table(c2) a2
where
    a1.get_key()=a2.get_key();
crec v3%ROWTYPE;
begin


    OPEN v1;
    
    FETCH v1 
        BULK COLLECT INTO table1;
        
    close v1;

    OPEN v2;

        FETCH v2 
        BULK COLLECT INTO table2;
        
    close v2;


    FOR indx IN 1 .. table1.COUNT 
    LOOP
        dbms_output.put_line(table1(indx).get_key());
    END LOOP;


    FOR indx IN 1 .. table2.COUNT 
    LOOP
        dbms_output.put_line(table2(indx).get_key());
    END LOOP;

    open v3(table1, table2);
        fetch v3 into crec;
     EXIT WHEN v3%NOTFOUND;
        dbms_output.put_line(crec.prod_c);
    close v3;

end;

ORA-06550: line 56, column 6:
PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-06550: line 56, column 6:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 68

declare cursor v1 is 
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual; 
table1 redd_tbTotali; 
cursor v2 is 
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('e','b','c',1,2,'d') from dual ; 
table2 redd_tbPatrim; 
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is 
select 
    a1.prod_c, 
    a1.contr_n, 
    a1.IMP_CAPIT_VERS, 
    a2.controvalore 
from 
    table(c1) a1, 
    table(c2) a2 
where 
    a1.get_key()=a2.get_key(); 
crec v3%ROWTYPE; 
begin 
 
 
    OPEN v1; 
     
    FETCH v1  
        BULK COLLECT INTO table1; 
         
    close v1; 
 
    OPEN v2; 
 
        FETCH v2  
        BULK COLLECT INTO table2; 
         
    close v2; 
 
 
    FOR indx IN 1 .. table1.COUNT  
    LOOP 
        dbms_output.put_line(table1(indx).get_key()); 
    END LOOP; 
 
 
    FOR indx IN 1 .. table2.COUNT  
    LOOP 
        dbms_output.put_line(table2(indx).get_key()); 
    END LOOP; 
 
    open v3(table1, table2); 
        fetch v3 into crec; 
     EXIT WHEN v3%NOTFOUND; 
      
        dbms_output.put_line(crec.prod_c); 
         
    close v3; 
 
end;

ORA-06550: line 56, column 6:
PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-06550: line 56, column 6:
PL/SQL: Statement ignored

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 69

declare cursor v1 is 
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual; 
table1 redd_tbTotali; 
cursor v2 is 
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('e','b','c',1,2,'d') from dual ; 
table2 redd_tbPatrim; 
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is 
select 
    a1.prod_c, 
    a1.contr_n, 
    a1.IMP_CAPIT_VERS, 
    a2.controvalore 
from 
    table(c1) a1, 
    table(c2) a2 
where 
    a1.get_key()=a2.get_key(); 
crec v3%ROWTYPE; 
begin 
 
 
    OPEN v1; 
     
    FETCH v1  
        BULK COLLECT INTO table1; 
         
    close v1; 
 
    OPEN v2; 
 
        FETCH v2  
        BULK COLLECT INTO table2; 
         
    close v2; 
 
 
    FOR indx IN 1 .. table1.COUNT  
    LOOP 
        dbms_output.put_line(table1(indx).get_key()); 
    END LOOP; 
 
 
    FOR indx IN 1 .. table2.COUNT  
    LOOP 
        dbms_output.put_line(table2(indx).get_key()); 
    END LOOP; 
 
    open v3(table1, table2); 
    LOOP 
     
        fetch v3 into crec; 
        EXIT WHEN v3%NOTFOUND; 
        dbms_output.put_line(crec.prod_c); 
         
    END LOOP; 
     
    close v3; 
 
end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c
a          
c          
d

Statement 70

declare cursor v1 is 
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('b','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('c','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('d','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual; 
table1 redd_tbTotali; 
cursor v2 is 
select redd_rtPatrim('a','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('c','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('d','b','c',1,2,'d') from dual union all 
select redd_rtPatrim('e','b','c',1,2,'d') from dual ; 
table2 redd_tbPatrim; 
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is 
select 
    a1.prod_c, 
    a1.contr_n, 
    a1.IMP_CAPIT_VERS, 
    a2.controvalore 
from 
    table(c1) a1, 
    table(c2) a2 
where 
    a1.get_key()=a2.get_key(); 
crec v3%ROWTYPE; 
begin 
 
 
    OPEN v1; 
     
    FETCH v1  
        BULK COLLECT INTO table1; 
         
    close v1; 
 
    OPEN v2; 
 
        FETCH v2  
        BULK COLLECT INTO table2; 
         
    close v2; 
 
 
    FOR indx IN 1 .. table1.COUNT  
    LOOP 
        dbms_output.put_line(table1(indx).get_key()); 
    END LOOP; 
 
 
    FOR indx IN 1 .. table2.COUNT  
    LOOP 
        dbms_output.put_line(table2(indx).get_key()); 
    END LOOP; 
 
    open v3(table1, table2); 
    LOOP 
     
        fetch v3 into crec; 
        EXIT WHEN v3%NOTFOUND; 
        dbms_output.put_line('st'); 
        dbms_output.put_line(crec.prod_c); 
        dbms_output.put_line(crec.contr_n); 
        dbms_output.put_line(crec.IMP_CAPIT_VERS); 
        dbms_output.put_line(crec.controvalore); 
        dbms_output.put_line('end'); 
 
    END LOOP; 
     
    close v3; 
 
end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c
st
a          
b                   
1
1
end
st
c          
b                   
1
1
end
st
d          
b                   
1
1
end

Statement 71

declare cursor v1 is 
select redd_rtTotali('a','b','c','d', current_date, current_date, 1,2,3,4,5,6,7) from dual union all 
select redd_rtTotali('b','b','c','d', current_date, current_date, 21,22,23,24,25,26,27) from dual union all 
select redd_rtTotali('c','b','c','d', current_date, current_date, 31,32,33,34,35,36,37) from dual union all 
select redd_rtTotali('d','b','c','d', current_date, current_date, 41,42,43,44,45,46,47) from dual; 
table1 redd_tbTotali; 
cursor v2 is 
select redd_rtPatrim('a','b','c',81,82,'d') from dual union all 
select redd_rtPatrim('c','b','c',5,52,'d') from dual union all 
select redd_rtPatrim('d','b','c',61,62,'d') from dual union all 
select redd_rtPatrim('e','b','c',71,72,'d') from dual ; 
table2 redd_tbPatrim; 
cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim)  is 
select 
    a1.prod_c, 
    a1.contr_n, 
    a1.IMP_CAPIT_VERS, 
    a2.controvalore 
from 
    table(c1) a1, 
    table(c2) a2 
where 
    a1.get_key()=a2.get_key(); 
crec v3%ROWTYPE; 
begin 
 
 
    OPEN v1; 
     
    FETCH v1  
        BULK COLLECT INTO table1; 
         
    close v1; 
 
    OPEN v2; 
 
        FETCH v2  
        BULK COLLECT INTO table2; 
         
    close v2; 
 
 
    FOR indx IN 1 .. table1.COUNT  
    LOOP 
        dbms_output.put_line(table1(indx).get_key()); 
    END LOOP; 
 
 
    FOR indx IN 1 .. table2.COUNT  
    LOOP 
        dbms_output.put_line(table2(indx).get_key()); 
    END LOOP; 
 
    open v3(table1, table2); 
    LOOP 
     
        fetch v3 into crec; 
        EXIT WHEN v3%NOTFOUND; 
        dbms_output.put_line('st'); 
        dbms_output.put_line(crec.prod_c); 
        dbms_output.put_line(crec.contr_n); 
        dbms_output.put_line(crec.IMP_CAPIT_VERS); 
        dbms_output.put_line(crec.controvalore); 
        dbms_output.put_line('end'); 
 
    END LOOP; 
     
    close v3; 
 
end;

a-b-d-c
b-b-d-c
c-b-d-c
d-b-d-c
a-b-d-c
c-b-d-c
d-b-d-c
e-b-d-c
st
a          
b                   
1
81
end
st
c          
b                   
31
5
end
st
d          
b                   
41
61
end

complex type

Additional Information