Message-ID: X-Trace: reader3.panix.com 1027525312 23523 216.52.73.254 (24 Jul 2002 15:41:52 GMT) Subject: Re: Has any one used dbms_utility.comma_to_table? From: "R Chin" NNTP-Posting-Host: 216.52.73.254 Lines: 45 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 References: Organization: PANIX Public Access Internet and UNIX, NYC Newsgroups: comp.databases.oracle.server X-Complaints-To: abuse@panix.com X-Newsreader: Microsoft Outlook Express 4.72.2106.4 Date: Wed, 24 Jul 2002 11:41:50 -0400 NNTP-Posting-Date: Wed, 24 Jul 2002 15:41:52 +0000 (UTC) Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!logbridge.uoregon.edu!panix!not-for-mail Xref: easynews comp.databases.oracle.server:155595 X-Received-Date: Wed, 24 Jul 2002 09:31:02 MST (news.easynews.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. > > > >