How to handle return type of Table%RowType in Store Procedure by JDBC
Date: 2000/07/06
Message-ID: <8k2989$f506_at_imsp212.netvigator.com>#1/1
Hi,
OracleCallableStatement l_stmt = (OracleCallableStatement)
connection.prepareCall("{ call ?:=GET_HOTELS(?) }");
l_stmt.registerOutParameter(4, ??? ,???);
^ ^
What I should put in above parameters???
There is no OracleType.RowType!!
I Got a Function which return row of table,
is it possible to retrieve those return into a ResultSet ?
from hotels
where id = pi_id;
rec_hotels hotels%rowtype;
begin
open cr_hotels;
fetch cr_hotels into rec_hotels;
if cr_hotels%notfound then
rec_hotels.ID := pi_id;
rec_hotels.name := null;
end if;
close cr_hotels;
return rec_hotels;
end;
/
Received on Thu Jul 06 2000 - 00:00:00 CEST
,NAME
,LOCATION
,ADDRESS
,CTY_ID
,PHONE
,FAX
,PHOTO_FILENAME
,HOTEL_URL
,HOC_CODE
,HOTEL_AIRPORT
,ADDRESS2
,ADDRESS3
,ADDRESS4
,FINDATA_OK