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: using an Hashtable in a Stored Procedure

Re: using an Hashtable in a Stored Procedure

From: Laura <f.marchioni_at_pride.it>
Date: 10 May 2007 08:42:30 -0700
Message-ID: <1178811750.228405.291660@h2g2000hsg.googlegroups.com>


On 10 Mag, 15:57, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On May 10, 8:51 am, Laura <f.marchi..._at_pride.it> wrote:
>
>
>
>
>
> > Hi all !
> > I have to write a little Stored Procedure which collects Varchars from
> > a sessionId and stores them in an Array. (One array for every
> > sessionId)
> > For example in Java it would be like this:
>
> > Hashtable hash = new Hashtable();
>
> > public addToHash(String sessionId,String value) {
> > hash.put(sessionId,value);
>
> > }
>
> > Is it possible to do the same in PL/SQL ? or do I have to write it in
> > Java and load it in Oracle ?
> > Thanks
> > Laura
>
> You can investigate using VARRAYs or PL/SQL tables. I'm sure you can
> find examples atwww.psoug.org/library.htmlor in the documentation athttp://tahiti.oracle.com.
>
> David Fitzjarrell- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -

thanks, I'll look for it.......... Received on Thu May 10 2007 - 10:42:30 CDT

Original text of this message

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