Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to use an associative array in

Re: How to use an associative array in

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 08 Jun 2006 14:24:02 GMT
Message-ID: <6qWhg.19809$VE1.6418@newssvr14.news.prodigy.com>


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.com
Received on Thu Jun 08 2006 - 09:24:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US