oracle用存储过程返回查询结果

oracle用存储过程返回查询结果 ï??oracleç??å??å‚?è?‡ç?‹è??å›?æŸ?è??ç??æ?œ åœ?oracleçš„precedureè??ä?ˆä??ç??cursorè??å›?å?•ä?ªå??ï?ˆå??å?•æ??è??å?•ï?‰ï?Œè? •ä?ˆå??ä??ç??ref cursorè??å›?è??å?•é›†ã?‚ å?‚æ?œæ??æŸ?è??1ä?ªåˆ?ï?Œå??ä??å?‚ä?‹ï?š [email=SYS@boss2>declare]SYS@boss2>declare[/email] 2 cursor v_cur is 3 select t2 from t; 4 begin 5 for v_t in v_cur 6 loop 7 dbms_output.put_line(v_t.t2); 8 end loop; 9 end; 10 / 1 2 3 4 5 6 6 PL/SQL procedure successfully completed. å?‚æ?œæ??ä?ªè??å?•é›†å??ä??å?‚ä?‹ï?š create or replace procedure test(cr_test in out sys_refcursor) is 3 begin 4 open cr_test for select * from t; 5 end; 6 / Procedure created. [email=SYS@boss2>variable]SYS@boss2>variable[/email] x refcursor [email=SYS@boss2>exec]SYS@boss2>exec[/email] test(:x) PL/SQL procedure successfully completed. [email=SYS@boss2>print]SYS@boss2>print[/email] x T1 T2 ---------------------------------------- ---------- aa 1 bbb 2 ? 3 c 4 T? 5 6 dd 6 7 rows selected. å??ç„?è??有å…?ä??æ??æ?•èƒ?è??å›?ï?Œè??里å??ä??å?šå•?å?†äº†ã?‚ Ð