Oracle 存储过程、游标的使用

一、存储过程

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);//在控制台输出