Inner loop example Oracle -ORA-06502: PL/SQL: sayısal veya değer hatası: karakter dizesi arabelleği çok küçük

If you have faced with ORA-06502: PL/SQL error . Check about variable size,



RA-06502: PL/SQL: sayısal veya değer hatası: karakter dizesi arabelleği çok küçük
ORA-06512: konum  satır 7
06502. 00000 -  "PL/SQL: numeric or value error%s"
*Cause:    An arithmetic, numeric, string, conversion, or constraint error
           occurred. For example, this error occurs if an attempt is made to
           assign the value NULL to a variable declared NOT NULL, or if an
           attempt is made to assign an integer larger than 99 to a variable
           declared NUMBER(2).
*Action:   Change the data, how it is manipulated, or how it is declared so
           that values do not violate constraints.

another cases: click here

declare 

    type country_list is table of varchar2(100);
    countries country_list := null; 
begin

    countries := country_list('Arzu Ar%' ,'Aleyna Tilki%' );
    for i in countries.first .. countries.last loop

      FOR aa IN ( select name,id from artist where name like countries(i)) LOOP

           DBMS_OUTPUT.PUT_LINE(aa.id || aa.name );

        END LOOP;

    end loop;

end;