Re: Returning an array from a procedure/ function

From: Simon Davies <a_person_uk_at_yahoo.co.uk>
Date: 11 Jul 2003 01:05:40 -0700
Message-ID: <6238724c.0307110005.64ac6bc6@posting.google.com>

rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0307100339.2d5ee7e6_at_posting.google.com>...
> varray is a static array
> pl/sql table is a dynamic sparse array. However, you can still get
> null pointer exceptions with it.. which is annoying.
>
> are yo using a varray? switch to a pl/sql table. initializations is
> virtually the same. it never needs to be extends. Its all wrapped. I
> rarely see varray used and only when you want to store the array in a
> table which you cant do with pl/sql tables.

I am using a pl/sql table:

TYPE ARRAY IS TABLE OF VARCHAR2(250);
> this should fix your problem. if not provide a code snipped and the
> error message.

So why if I try to assign the vale of one array to another do I encounter problems unless the arrays have been initialised in the manner I mentioned earlier in thread.

> im right your a c/c++ programmer right?

Yep.

Simon. Received on Fri Jul 11 2003 - 03:05:40 CDT