Re: HELP: Scrollable ResultSet, Stored Procedure, JAVA

Hi Vogeler:

Have you found any solution for the question u have posted... i too am having the same problem...

please post the solution if you have found any...

Thanks,
Phani
Originally posted by Volkhard Vogeler
> Hello,
>
> i do have following lines of code:
>
> strSQL="{ ? = call vv.test() }";
> objCCmd=objCon.prepareCall(
> strSQL,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
> objCCmd.registerOutParameter(1,OracleTypes.CURSOR);
> objCCmd.execute();
> objRS=(ResultSet)objCCmd.getObject(1);
> test() is a function in package vv: function test return udtObjRS;
>
> What i get is a forward-only ResultSet. How can i get a scrollable
> ResultSet
> from a PL/SQL-function? Is this supported?
>
> best regards
>
> Volkhard
> --
> Volkhard Vogeler
> CEO
> Vogeler AG
> Nibelungenstr. 15
> D-90513 Zirndorf
>
> Tel: +49(911)4740624

Www.Vogeler-AG.De

--
Posted via http://dbforums.com