does a procedure returns cursor, if so, how to hadle that in java

[Praveen palukuri]

hi,
can we send a cursor from procedure. if so, how to handle that cursor in java. please help me.

Thank u.

[Sujith Kanaparthi]

Hi Praveen,

A cursor can be used as an out parameter in a procedure.If you want that cursor to be handled in Java then use CallableStatement.

ArrayList cursor1 = new ArrayList();
CallableStatement cst = connection.prepareCall("{call YourProc(?,?)}");
cst.setString(1,in_param);
cst.registerOutParameter(2,oracle.jdbc.driver.OracleTypes.CURSOR);
cst.execute();
cursor1 =(ResultSet)cst.getObject(2);

Where YourProc as one in param and one out param which is a cursor and store that cursor in an arraylist to use the data available in it

Regards,
Sujith

[Praveen palukuri]

thank u sujith,
Here i'm using SqlServer. in this i couldn't find any datatype like cursor. so would u please tell me how to achieve using sqlserver

[Sujith Kanaparthi]

Here i'm using SqlServer.

Sorry Praveen I have never worked on sql server

Regards,
Sujith