procedure GetRoomByID --根据条件查询数库表符合要求的记录.
(
ARoomRkey in Rooms.RoomRkey%Type,
ResultData out sp_Rooms.rooms_row
)
as
begin
open ResultData for
select * from Rooms where RoomRKey=ARoomRKey;
end GetRoomByID;
select * from rooms where roomrkey = '101'
这样一条SQL语句,我通过存储过程游标形式来实现:
调用过程如下:
begin
-- Call the procedure
sp_rooms.getroombyid(aroomrkey => :aroomrkey,
resultdata => :resultdata);
end;
请问这个OUT参数类型怎么输入?
(
ARoomRkey in Rooms.RoomRkey%Type,
ResultData out sp_Rooms.rooms_row
)
as
begin
open ResultData for
select * from Rooms where RoomRKey=ARoomRKey;
end GetRoomByID;
select * from rooms where roomrkey = '101'
这样一条SQL语句,我通过存储过程游标形式来实现:
调用过程如下:
begin
-- Call the procedure
sp_rooms.getroombyid(aroomrkey => :aroomrkey,
resultdata => :resultdata);
end;
请问这个OUT参数类型怎么输入?
type curData is ref cursor;
resultdata curData;
aroomrkey varchar2(100);
beginsp_rooms.getroombyid(aroomrkey,resultdata);end;
你看看,还真没有这么用过,有什么特殊意义吗?