17,086
社区成员
发帖
与我相关
我的任务
分享
procedure countries_in_same_region
(in_region_name in wf_world_regions.region_name%type,
out_cur out traveler_assistance_package.ref_cur
) is
begin
open out_cur for
Select CURRENCY_NAME, REGION_NAME,COUNTRY_NAME
FROM WF_COUNTRIES,WF_CURRENCIES,WF_WORLD_REGIONS
where region_name=in_region_name and
WF_CURRENCIES.CURRENCY_CODE=WF_COUNTRIES.CURRENCY_CODE and
WF_WORLD_REGIONS.REGION_ID=WF_COUNTRIES.REGION_ID;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('NO DATA FOUND');
end countries_in_same_region;
另外,使用ref 游标可以取得多个表的数据吗,还是ref 游标只能操作一个表?