Wrox Home  
Search P2P Archive for: Go

  Return to Index  

servlets thread: java how to invok oracle packeages which return a RecordSet?


Message #1 by "billczwen" <billczwen@e...> on Mon, 28 Oct 2002 10:18:05
java how to invok oracle packeages which return a RecordSet? 

packeage is 

create or replace package pkgzwTest is 
TYPE myrctype IS REF CURSOR; 

procedure P_zwTest(o_RecordSet OUT myrctype); 
end pkgzwTest; 
create or replace package body pkgzwTest is 
procedure P_zwTest(o_RecordSet OUT myrctype) 
as 
begin 
open o_RecordSet for 
select custname,summary from custinfo; 
return; 
end P_zwTest;  
end pkgzwTest; 



how to return all of the record? 

  Return to Index