Re: oracle 9: collections syntax in proc?

Steve Howard wrote:

> To fix your immediate syntax problem, you need to create your own type,
> and pass that. In your package spec, something like...
>
> t_IDCollection IS TABLE OF INTEGER INDEX BY BINARY INTEGER;
>
> ...and in your proc definition...
>
> p_IDCollection IN t_IDCollection

ah, i see... yes that makes sense. created a new package-level type, use that in the procs.

thanks!
matt Received on Tue Jun 27 2006 - 11:05:56 CDT