comma_to_table is really designed for db IDENTIFIERS - table names, column
names...
so max length of the elements is 30
What you had there it just couldn't read...you gotta send the string in like
'"9.0.2","9.0.1"' (double-q the elements), otherwise just write a parser
function yourself..
robert
Sunil wrote in message ...
>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 - 10:41:50 CDT
