Re: using an Hashtable in a Stored Procedure

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 at www.psoug.org/library.html or in the documentation at http://tahiti.oracle.com.

David Fitzjarrell Received on Thu May 10 2007 - 08:57:15 CDT