Oracle ´æ´¢¹ý³Ì½á¹û¼¯

Oracle´æ´¢¹ý³ÌÄܲ»ÄÜ·µ»ØÒ»¸ö½á¹û¼¯
·µ»ØµÄÊý¾Ý½á¹¹Í¬ SELECT * from µÄÊý¾Ý½á¹¹Ò»Ñù

MySQL¿ÉÒÔ×öµ½Õâ¸ö£¬²»¹ýËƺõOracleûÓÐÕâ¸öÌØÐÔÄØ


·¢ÌûÎÊÎʸ÷λ

---

create or replace procedure proc(p_resultset out sys_refcursor)
as
begin
open p_resultset for select * from ..;
end proc;

---

ÍêÈ«Äܹ»Âú×ãÄãµÄÒªÇóoracle¡£
1Â¥µÄÄÇÖÖ·½·¨¾Í¿ÉÒÔ¡£
ÓÃÓαꡣ

---

ºÃµÄ£¬Ð»Ð»
µ«ÊÇÈç¹ûÎÒÒª²âÊÔµ÷ÓÃÕâ¸öSPÄØ£¬ÔÚTOADÀïÃæÓ¦¸ÃÔõô¶¨ÒåÕâ¸öp_resultset out sys_refcursorÄØ£¿

---

Òâ˼¾ÍÊÇ˵
create or replace procedure proc(p_resultset out sys_refcursor)
as
begin
open p_resultset for select * from ..;
end proc;


È»ºóÎÒÏëÔÚ TOADϵ÷Óà call();
ÕâÑùµ÷ÓþͿÉÒÔÏÔʾ½á¹û¼¯Ó¦¸ÃÈçºÎ×öÄØ£¿

---

declare
p_result sys_refcursor;
begin
proc(p_result);
--
-- cursor ´¦Àí
end;
/

---

OK,thank you every body!!