HELP: Scrollable ResultSet, Stored Procedure, JAVA

From: Volkhard Vogeler <VolkhardV_at_Vogeler-AG.de>
Date: Mon, 18 Nov 2002 22:36:51 +0100
Message-ID: <arbmhk$6cq$04$1_at_news.t-online.com>

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

Received on Mon Nov 18 2002 - 22:36:51 CET