Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Associative arrays in Oracle PL/SQL as parameters, use with Java
On 3 Mar 2005 14:46:15 -0800, googledude_at_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 Anything with a type definition can be passed within pl/sql
2 that I don't know.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Mar 03 2005 - 17:26:37 CST