• Post Reply Bookmark Topic Watch Topic
  • New Topic

Can a PL/SQL procedure return collection ?  RSS feed

 
Rakesh Gadre
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am calling a Stored procedure using CallableStatement in JSP. Can I have multiple rows using a single OUT parameter ?
Rakesh
 
Geeta Ramasami
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!