Re: dbms_utility.comma_to

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/03/05
Message-ID: <35022854.9912813@192.86.155.100>#1/1

A copy of this was sent to yizhang22_at_hotmail.com (if that email address didn't require changing) On Thu, 05 Mar 1998 11:57:48 -0600, you wrote:
>I am trying to use dbms_utility.comma_to_table procedure with
>the following code in sql worksheet
>

Its because comma_to_table doesn't do what you think it does.... If you take your example change '1,2,3,4,5' to 'all_users,all_objects,all_indexes' for example, it would work (since all_users, all_objects, all_indexes are real object names). The definition of comma_to_table:

PROCEDURE comma_to_table( list IN VARCHAR2,

                            tablen OUT BINARY_INTEGER,
                            tab    OUT uncl_array);

Convert a comma-separated list of names into a PL/SQL table of names
This uses name_tokenize to figure out what are names and what are commas

is not very clear. It can be used to generate a table of object NAMES (real database objects) but not a generic list of items.

the missing identified stems from the fact you probably don't have a database object named "1"

>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

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Mar 05 1998 - 00:00:00 CST

Re: dbms_utility.comma_to_table