Re: Help:JDBC and StoredProcedures

Hello Rizwan,

thanks - this works.

"Rizwan Qazi" <rizwanhqazi_at_hotmail.com> schrieb im Newsbeitrag news:a5c3d23d.0211142136.488101f5_at_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 Fri Nov 15 2002 - 03:38:46 CST