dbms_utility.comma_to

From: <yizhang22_at_hotmail.com>
Date: 1998/03/05
Message-ID: <6dmp1c$57f$1@nnrp1.dejanews.com>#1/1

I am trying to use dbms_utility.comma_to_table procedure with the following code in sql worksheet

declare
csv_string varchar2(30):='1,2,3,4,5,6,7,8,9,10'; tablen binary_integer;
mytab dbms_utility.uncl_array;
begin
dbms_utility.comma_to_table(csv_string, tablen, mytab);
--dbms_output.put_line( to_char(tablen));
end;

and get the following error:

ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 78
ORA-06512: at "SYS.DBMS_UTILITY", line 107
ORA-06512: at line 6

can someone please tell me what's wrong? your help is greatly appreciated.

Yi Zhang
yizhang22_at_hotmail.com

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 05 1998 - 00:00:00 CST