Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!sjc70.webusenet.com!news.webusenet.com!news.isc.org!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: a_person_uk@yahoo.co.uk (Simon Davies)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Returning an array from a procedure/ function
Date: 7 Jul 2003 01:30:03 -0700
Organization: http://groups.google.com/
Lines: 29
Message-ID: <6238724c.0307070030.43564586@posting.google.com>
References: <6238724c.0307040746.65536382@posting.google.com> <mn4Oa.9373$ZT5.3228@news2.east.cox.net>
NNTP-Posting-Host: 137.44.17.64
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057566604 14272 127.0.0.1 (7 Jul 2003 08:30:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 08:30:04 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129080

"Ryan" <rgaffuri@cox.net> wrote in message news:<mn4Oa.9373$ZT5.3228@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.