Hi,

I hope you can help me, I have created a simple function within a package which I have shown below. This function converts all the values within an associaitve array into one varchar.

PACKAGE SPEC

TYPE assoc_array IS TABLE OF VARCHAR2 (1000);


FUNCTION f_assoc_array (
inputs IN assoc_array
)
RETURN VARCHAR2;


PACKAGE BODY assoc
IS
FUNCTION f_assoc_array (
inputs IN assoc_array
)
RETURN VARCHAR2
IS
str_of_inputs VARCHAR2 (32767);
BEGIN
FOR i IN inputs.FIRST .. inputs.LAST
LOOP
CASE i
WHEN inputs.COUNT
THEN
str_of_inputs :=
str_of_inputs || '''' || inputs (i) || ''''
|| ')';
ELSE
str_of_inputs :=
str_of_inputs || '''' || inputs (i) || ''''
|| ',';
END CASE;
END LOOP;

RETURN str_of_inputs;
END f_assoc_array;
end assoc;

Everytime I try to test this function using the following script I receive the following error message.

PLS-00306 wrong number or types of arguments in call to 'string'

DECLARE
TYPE zzz IS TABLE OF VARCHAR2 (32767)
INDEX BY PLS_INTEGER;
abc zzz;
yyy varchar2(1000);
BEGIN
abc (1) := 'Steve';
abc (2) := 'Paul';
yyy:= ass_array.f_ass_array (abc);
DBMS_OUTPUT.put_line (yyy);
END;

ops$tkyte%ORA10GR2> declare
  2          abc ASSOC.ASSOC_ARRAY := ASSOC.ASSOC_ARRAY('Steve', 'Paul' );
  3  begin
  4          dbms_output.put_line( assoc.f_assoc_array(abc) );
  5  end;
  6  /
'Steve','Paul')

PL/SQL procedure successfully completed.

create type associative_array as table of number index by varchar2(30);

l_data('Steve') := 42;
l_data('Paul' ) := 55;