Re: oracle 9: collections syntax in proc?

From: <matt_at_mailinator.com>
Date: 27 Jun 2006 09:09:24 -0700
Message-ID: <1151424563.908582.14260@x69g2000cwx.googlegroups.com>

William Robertson wrote:

> Reading that back, I'm not sure I made the point that instead of this:
>
> PROCEDURE UpdateFurinishedEquipmentTag (
> p_idcollection TABLE OF INTEGER -- Invalid
> ...
> )
>
> you would use this:
>
> PROCEDURE UpdateFurinishedEquipmentTag (
> p_idcollection INTEGER_TT -- Your new type
> ...
> )

...got it, thanks. will give this a try.

btw, im from a MS SQL background (t-sql). in my work w/ it ive never tried and thought to try something like this. are collections of this sort unique to oracle (p-sql)?

thanks!
matt Received on Tue Jun 27 2006 - 11:09:24 CDT