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 May 10, 11:42 am, Laura <f.marchi..._at_pride.it> wrote:
> 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.htmlorin the documentation athttp://tahiti.oracle.com.
>
> > David Fitzjarrell- Nascondi testo tra virgolette -
>
> > - Mostra testo tra virgolette -
>
> thanks, I'll look for it..........- Hide quoted text -
>
> - Show quoted text -
Also look at DBMS_CRYPTO package for hashing function. Received on Thu May 10 2007 - 10:46:12 CDT