Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc,comp.lang.java.programmer,comp.databases.oracle.server Subject: Re: Associative arrays in Oracle PL/SQL as parameters, use with Java Date: Thu, 03 Mar 2005 17:03:22 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1109898013.70567@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1109889975.725357.101370@f14g2000cwb.googlegroups.com> In-Reply-To: <1109889975.725357.101370@f14g2000cwb.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 38 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:116983 comp.lang.java.programmer:499210 comp.databases.oracle.server:237432 googledude@hotmail.com wrote: > Is it possible to pass Oracle associative arrays as PL/SQL parameters ? > I have basically gone through a bunch of articles on Oracle's site, > google, search engine. I have yet to find any decent examples of using > associative arrays as parameters. > > I am shocked/surprised that a company of the size of oracle has such > poor search tools on their web site with tons of irrelevant > information. I also tried to look through the O'Reilly books on PL/SQL > (3rd edition). The book has no contextual coverage on my problem (it is > loaded with elementary type information and examples). As you can tell, > I am frustrated and can't find any in-depth coverage on this issue. > > 1. Can I use associative arrays (specifically the ones indexed by > varchar2) as parameters between various pl/sql functions/procedures ? > > 2. What, if any, corresponding data structures and constructs can be > used on the java side to map to associative arrays (NO, i am not > interested in using varrays and/or nested tables). > > 3. Anyone care to share any examples that use these features ? > > Thanks humbly for your help in advance! 1. Yes. 2. Don't know but if not you could always move the values to a ref cursor or array. 3. http://www.psoug.org click on Morgan's Library click on Associative Arrays -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)