dbms_utility.comma_to_table??

From: Yogen Sanghani <yogen_at_astro.ocis.temple.edu>
Date: 1995/12/20
Message-ID: <4b9oif$3l0_at_cronkite.ocis.temple.edu>#1/1

Has anyone been able to use the procedure COMMA_TO_TABLE from DBMS_UTILITY package successfully? I have tried to use this in numerous different ways but I haven't been able to build the procedure successfully.

Here's how the procedure COMMA_TO_TABLE is described:

PROCEDURE dbms_utility.comma_to_table
 Argument Name Type In/Out Default?

• ----------------------- ------ -------- LIST VARCHAR2 IN TABLEN BINARY_INTEGER OUT TAB TABLE OF VARCHAR2(227) OUT

Here's the section of code where I'm trying to use this procedure:

.....

TYPE words_table_type IS

        TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
.....

 description VARCHAR2(30);
 desc_words_table words_table_type;
 desc_tab_len BINARY_INTEGER;
......

DBMS_UTILITY.COMMA_TO_TABLE(description, desc_tab_len, desc_words_table);

....

When I try to build this procedure, I get following error:

LINE/COL ERROR

-------- -----------------------------------------------------------------
124/4    PLS-00306: wrong number or types of arguments in call to
     'COMMA_TO_TABLE'

124/4 PL/SQL: Statement ignored

I've tried changing words_table_type to TABLE OF VARCHAR(227), that did not help either. Any ideas?

Thanks for any response.

---

Yogen. Received on Wed Dec 20 1995 - 00:00:00 CET