create or replace package MAnlyse
is
-- Public type declarations
type M_Cursor is ref cursor;
-- Public function and procedure declarations
procedure anlyse(
myCursor out M_Cursor,
V_id in Number
);
end ;
create or replace package body MAnlyse
is
procedure anlyse
(
myCursor out M_Cursor,
V_id in Number
)
is
begin
open myCursor for
select * from param_city t where t.id>V_id ;
end anlyse;
end MAnlyse;
这些都在PL/SQL 中执行成功后，我们点击存储过程名anlyse右键，测试。弹出测试窗口后在窗口下面的表格中输入v_id的值，点击执行，成功后点击<Cursor>后的小按钮，就可以查看结果。
责任编辑：小草
