DBMS_UTLILITY.TABLE_TO_COMMA problem

Hi,
We are trying to write a function using dbms_utility.table_to_comma. We think we are doing everything correctly, but we keep getting PLS-00306: wrong number or types of arguments in call to 'TABLE_TO_COMMA'. We are using 8.0.5.0.0 on NT. Thanks for any insight on this.

Here's the code:

CREATE OR REPLACE PACKAGE LEG_TREE_PKG as function leg_channel_tree(i_leg_id in number, eff_date in date) return varchar2;
pragma restrict_references (leg_channel_tree, WNDS, wnps); end;
/

CREATE OR REPLACE PACKAGE BODY leg_tree_pkg as  /*CREATE OR REPLACE*/
 FUNCTION LEG_CHANNEL_TREE -- peteg 6/4/99  ( i_leg_id IN number,eff_date IN date) RETURN VARCHAR2  IS

TYPE channel_tree_type IS TABLE OF NUMBER NOT NULL INDEX BY BINARY_INTEGER;
 channel_tree channel_tree_type;

 row_list VARCHAR2(4000);
 x_row_count binary_integer;
 count_out binary_integer;

CURSOR channel_tree_cur
 IS
 SELECT CHN_CHN_ID
 FROM CHANNELS
 WHERE (eff_date BETWEEN CHN_BEGIN_DATE AND (CHN_END_DATE - 1))  START WITH CHN_LEG_ID = i_leg_id
 CONNECT BY CHN_CHN_ID = PRIOR DECODE(CHN_CHN_ID_PARENT,  CHN_CHN_ID, NULL, CHN_CHN_ID_PARENT);
 channel_tree_rows BINARY_INTEGER := 1;  BEGIN

• open the channel tree cursor here FOR channel_tree_rec IN channel_tree_cur LOOP channel_tree(channel_tree_rows) := channel_tree_rec.CHN_CHN_ID;

 channel_tree_rows := channel_tree_rows + 1;  x_row_count := sql%rowcount;

 dbms_utility.TABLE_TO_COMMA( CHANNEL_TREE , count_out , ROW_LIST);  END LOOP;
 RETURN row_list;

 EXCEPTION
 WHEN NO_DATA_FOUND THEN
   channel_tree(channel_tree_rows) := NULL;  RETURN NULL;  END;
 END LEG_TREE_PKG;
/

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 17:26:57 CDT