> On 10 Mag, 15:57, "fitzjarr
@cox.net" <fitzjarr
@cox.net> wrote:
> > On May 10, 8:51 am, Laura <f.marchi@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 -
>
Also look at DBMS_CRYPTO package for hashing function.
Laura <f.marchi
@pride.it> writes:
> 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
Hello Laura,
you could try something like this:
subtype tvalue is varchar2(1000);
type thash is table of tvalue index by varchar2;
hashtab thash;
procedure addtohash(sessionid in varchar2, value in varchar2) is
begin
hashtab(sessionid) := value;
end addtohash;
For this to work, you need at least Oracle 9.2.
Since I'm writing this from memory, the syntax may need slight corrections.
Hope that helps,
Lothar
--
Lothar Armbrster | lothar.armbrues@t-online.de
Hauptstr. 26 |
65346 Eltville |
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
