If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I'm missing the declaration of your ref_cursor. Presumably it's declared as kind of a rowtype of the scott.t1 table.
Try selecting the columns by name in your select in your java code and compare them with the order in the ref_cursor declaration.
I think you're problem is there.

I'm missing the declaration of your ref_cursor. Presumably it's declared as kind of a rowtype of the scott.t1 table.
Try selecting the columns by name in your select in your java code and compare them with the order in the ref_cursor declaration.
I think you're problem is there.

I am getting the problem in the call
cstmt.setObect(1, (ResultSet)set, Types.OTHER);
Please see my first post. I hope you got the problem, Please try
testing it and let me know if I am still doing anything wrong
Over here..