CREATE OR REPLACE PROCEDURE ll_02 (p_cursor OUT sys_refcursor) IS v_sql varchar2(50); BEGIN v_sql:='SELECT * from ' || 'b_areas'; OPEN p_cursor FOR v_sql; END ll_02; / --存储过程返回一个游标
DECLARE P_CURSOR sys_refcursor; rec b_areas%rowtype; BEGIN -- P_CURSOR := NULL; Modify the code to initialize this parameter ET_STATISTICS.LL_02 ( P_CURSOR ); fetch P_CURSOR into rec; loop dbms_output.put_line(rec.area_id); fetch P_CURSOR into rec; exit when (P_CURSOR%notfound);
建议的开发工具如下:PL/SQL DEVELOPER,TOAD FOR ORACLE,JAVA DEVELOPER
CREATE PROCEDURE NAME....
謝謝各位大哥!但我什麼測試一個存儲過程的運行結果?用什麼語句?
==================================
toad中begin
存储过程名字(参数);
end;
v_sql varchar2(50);
BEGIN
v_sql:='SELECT * from ' || 'b_areas';
OPEN p_cursor FOR
v_sql;
END ll_02;
/
--存储过程返回一个游标
P_CURSOR sys_refcursor;
rec b_areas%rowtype;
BEGIN
-- P_CURSOR := NULL; Modify the code to initialize this parameter ET_STATISTICS.LL_02 ( P_CURSOR );
fetch P_CURSOR into rec;
loop
dbms_output.put_line(rec.area_id);
fetch P_CURSOR into rec;
exit when (P_CURSOR%notfound);
end loop;END; --结果
N
H
X
O
E
S
M