Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: using an Hashtable in a Stored Procedure
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
![]() |
![]() |