Can a PL/SQL procedure return collection ?

[Rakesh Gadre]

Hi,
I am calling a Stored procedure using CallableStatement in JSP. Can I have multiple rows using a single OUT parameter ?
Rakesh

[Geeta Ramasami]

Hi,
If ur stored procedure is returning multiple rows then used REF cursor in the stored procedure..
use something of this type.
CallableStatement cstmt = conn.prepareCall(call procname())
cstmt.registerOutParameter(1, OracleTypes.CURSOR);
cstmt.setString(2, i_etype);
cstmt.executeUpdate();

Cheers
Geeta
[ April 15, 2003: Message edited by: Geeta Ramasami ]