dbms_utility.comma_to_table problem

From: Andy Hardy <Andy_Hardy_at_camk.demon.co.uk>
Date: 1997/10/24
Message-ID: <AMveMBAHTMU0Mw5o_at_camk.demon.co.uk>#1/1


Hi,

[Quoted] I have the following procedure:

procedure test
is

        my_string varchar2(80) := '1,2,3,4,5';

        my_table dbms_utility.uncl_array;
        my_len BINARY_INTEGER;
 begin
        dbms_utility.comma_to_table(my_string, my_len, my_table);
        
        FOR v_index IN 1..my_len LOOP
                dbms_output.put_line(my_table(v_index));
        END LOOP;

end;

When I run it I get:

ERROR at line 1:

ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 54
ORA-06512: at "SYS.DBMS_UTILITY", line 83
ORA-06512: at "ORCLOWNER.TEST", line 8
ORA-06512: at line 1

Any ideas?

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG
Received on Fri Oct 24 1997 - 00:00:00 CEST

Original text of this message