HOw does Java Stored procs support for returning multiple rows (REFCURSORS) in 9i

[gary]

Hi, everyone,

One thing I need your help.

In Oracle 9i, documentation wrote down: "Java Stored procedures support for returning multiple rows (REFCURSORS)". Could anyone tell me how it work? it will be greate help if you can give me some examples. Thanks very much.

Gary

[TimHall]

Hi.

I've used this method alot for ASP.

http://www.oracle-base.com/Articles/...Recordsets.asp

You must use the Oracle driver, not the MS one, when making the connections. There are examples in the documentation for Java etc.

Cheers