Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to use an associative array in
jwheeler_at_assassincat.com wrote:
>
> While I've found a couple of different way to declare the array in the
> type header, I can't figure out how to instantiate it in the
> ODCIAggregateInitialize() function of the type body.
>
> I'd follow up on this question at Ask Tom, but the site doesn't seem to
> be accepting new posts at the moment.
No need to bother Tom with that. Put something like:
"type mytype is table of EMP%ROWTYPE index by varchar2(10)" and
declare a variable of that type. It's all right in the PL/SQL manual:
http://tinyurl.com/hm7gw
In other words, your question can be answered by the phrase "read the
fine manual" or equivalent.
-- Mladen Gogala http://www.mgogala.comReceived on Thu Jun 08 2006 - 09:24:02 CDT
![]() |
![]() |