SQL & PL/SQL

I need to return a cursor of results to my Java class.

I also want to process all the entries in the cursor first to calculate a hash.

Now I can do this by effectively running the query twice, but it would be nice if I could 'reset' the cursor having fetched all the items and calculated my hash function.

The docs seem to imply that this can be done, but I haven't found out the mechanics of this.

Also at the moment I'm just using a SYS_REFCURSOR to return stuff to java and I'm not entirely sure it works the same with the sort of cursor you use to fetch...

Thanks

Iain