oracle´æ´¢¹ý³Ì´úÂëʵÀý

1¡¢ÓÃÀ´²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE INSERTAMOUNTTEST
(
ST_NUM        IN     NUMBER,
ED_NUM        IN     NUMBER
)
IS
BEGIN
declare
       i   number;
begin
FOR i IN ST_NUM..ED_NUM LOOP
INSERT INTO tb values(i,i,'3','3','3',100,'0');
END LOOP;
end;
END;
ÔËÐУº
sql>execute INSERTAMOUNTTEST(1,45000)   -- Ò»´Î²åÈë45000Ìõ²âÊÔÊý¾Ý
2¡¢´Ó´æ´¢¹ý³ÌÖзµ»ØÖµ
create or replace procedure spaddflowdate
(
varAppTypeId               in varchar2,
varFlowId                  in varchar2,
DateLength                 in number,
ReturnValue                out number    --·µ»ØÖµ
)
is
begin
insert into td values(varAppTypeId,varFlowId,DateLength)
returning 1 into ReturnValue;   --·µ»ØÖµ
commit;
exception
when others then
rollback;
end;
´æ´¢¹ý³ÌµÄÖ´ÐÐ
sql>variable testvalue  number;
sql>execute spaddflowdate('v','v',2,:testvalue);
sql>print
¾Í¿ÉÒÔ¿´µ½Ö´Ðнá¹û
3¡¢ÓðüʵÏÖ´æ´¢¹ý³Ì·µ»ØÓα꣺
create  or  replace  package  test_p 
as 
 
type  outList  is  ref  cursor; 
 
PROCEDURE  getinfor(taxpayerList  out  outList); 
 
end  test_p; 
/ 
create  or  replace  package  body  test_p  as  PROCEDURE  getinfor(taxpayerList out  outList)  is  begin 
      OPEN  taxpayerList    FOR  select  *  from