Re: Help:JDBC and StoredProcedures

From: Rizwan Qazi <rizwanhqazi_at_hotmail.com>
Date: 14 Nov 2002 21:36:57 -0800
Message-ID: <a5c3d23d.0211142136.488101f5@posting.google.com>

Here is the relevant code:

            CallableStatement statement;
            statement = mmCon.prepareCall("{ call 

ASS_RELEASES.get_module_release_records(?,?,?,?,?,?)}");

            statement.setInt(1,linecardPlatformId);
            statement.setInt(2,platformFamilyId);
            statement.registerOutParameter(3,java.sql.Types.VARCHAR);
            statement.registerOutParameter(4,java.sql.Types.VARCHAR);
            statement.registerOutParameter(5,OracleTypes.CURSOR);
            statement.registerOutParameter(6,OracleTypes.CURSOR);

            statement.execute();

            String moduleName = statement.getString(3);
            String platformName = statement.getString(4);

            ResultSet resultsAssRelease = (ResultSet)
statement.getObject(5);
            //results.setFetchSize(1000);
            Vector assReleaseVector =

dbutil.toVector(resultsAssRelease);

            ResultSet resultsUnAssRelease = (ResultSet) statement.getObject(6);

The code is pretty self explanatory...
The parameters 5 and 6 are ref cursors.

Regards,
Rizwan

"Volkhard Vogeler" <VolkhardV_at_Vogeler.com> wrote in message news:<ar0t74$k80$1_at_ork.noris.net>...
> Hello,
>
> i want to call a StoredProcedure, which has a REFCURSOR as out-Parameter.
> With OLEDB this StoredProcedures can return a resultset to the client.
> How can i call this SP within JDBC and can get the resultset?
>
> best regards
>
> Volkhard
>
> --
> Volkhard Vogeler
> Vorstand
>
> Vogeler AG
> Nibelungenstr. 15
> D-90513 Zirndorf
>
> Tel: +49(911)4740624
> Www.Vogeler-AG.De
Received on Thu Nov 14 2002 - 23:36:57 CST