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
end;
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 AEGReceived on Fri Oct 24 1997 - 00:00:00 CEST