一、存储过程
1.声明存储过程
create or replace package package_aa is
procedure bb(v_id in number,
v_code in number);
end package_aa;
2.存储过程定义
create or replace package body package_aa is
procedure bb(v_id in number,
v_code in number) is
begin
............
end;
end package_aa;
3.存储过程调用
call package_aa.bb(1,1)
二、游标
cursor cursor_items is
select t.itemid
from t_item t
for items in cursor_items
dbms_output.put_line(items.itemid);//在控制台输出