Re: Returning an array from a procedure/ function

From: Simon Davies <a_person_uk_at_yahoo.co.uk>
Date: 7 Jul 2003 01:30:03 -0700
Message-ID: <6238724c.0307070030.43564586@posting.google.com>

"Ryan" <rgaffuri_at_cox.net> wrote in message news:<mn4Oa.9373$ZT5.3228_at_news2.east.cox.net>...

> i follow the syntax, but what is the error your getting? or what is being
> returned? are you printing out the
> content of the PL/SQL table to see if the values are return?
>
> im assuming your coming from an Object oriented backgroudn because
>
> MyArray ARRAY := ARRAY('','','','','','','','','','','','','','','');
>
> as a constructor. its not necessary. Arrays are wrapped in Oracle.
> Initialization is taken care of for you.

OK. So I now have the following declaration:

MyArray ARRAY;

> please provide more detail.

The error message I am getting is below:

ORA-06550: line 1, column 7544:
PLS-00306: wrong number or types of arguments in call to 'MYPROC'

The error is occuring on the page which call the function returning the array.

Cheers,

Simon. Received on Mon Jul 07 2003 - 03:30:03 CDT