Did I say 32 chars max for identifiers? Should be 30, really. Why does
32 sound and look more familiar?
"R Chin" <rchin_at_panix.com> wrote in message news:<ahmhs0$mv3$2_at_reader3.panix.com>...
> 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 - 17:15:13 CDT
