Has any one used dbms_utility.comma_to_table?

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Wed, 24 Jul 2002 19:44:27 +0530
Message-ID: <iHy%8.14$V%4.33@news.oracle.com>

I have the following code

create or replace procedure test789 is

   l_list   varchar2(1000) := '9.0.2,9.0.1';
   l_tablen binary_integer;
   l_tab    dbms_utility.uncl_array;

begin

    dbms_utility.comma_to_table(l_list, l_tablen, l_tab);

    for i in 1 .. l_tablen
    loop

        dbms_output.put_line('rdbms_ver_supported=' || l_tab(i));     end loop;
end test789;

which throwing the error shown below

ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 105
ORA-06512: at "SYS.DBMS_UTILITY", line 140
ORA-06512: at "SYS.DBMS_UTILITY", line 182
ORA-06512: at "SFRANKLI14.TEST789", line 8
ORA-06512: at line 1

Any suggestions?

Thanks,
Sunil. Received on Wed Jul 24 2002 - 09:14:27 CDT