Calling stored procedures with JDBC

Thread view:

MAB - 04 Aug 2004 06:31 GMT

I need to find good examples/tutorials for calling stored procedures ( of
oracle ) with in/out parameters which can be recordsets/cursors etc.
Meanwhile i'm searching google. If any of you happen to know some good links
I would very much appreciate it.

thx.

Reply to this Message

MAB - 04 Aug 2004 08:24 GMT

OK I found how to do this except for oracle procedures that return a cursor
i.e output parameter is a variable cursor.

thx for any help.

> I need to find good examples/tutorials for calling stored procedures ( of
> oracle ) with in/out parameters which can be recordsets/cursors etc.
> Meanwhile i'm searching google. If any of you happen to know some good links
> I would very much appreciate it.
>
> thx.

Reply to this Message

Murray - 04 Aug 2004 09:18 GMT

> OK I found how to do this except for oracle procedures that return a cursor
> i.e output parameter is a variable cursor.

You need to use OracleTypes.CURSOR as the type (Oracle JDBC driver must be
in the classpath)

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...