Oracle´æ´¢¹ý³ÌÓ﷨ѧϰ

´æ´¢¹ý³Ì´´½¨Óï·¨£º
 
£¨1£©ÎÞ²Î
create or replace procedure ´æ´¢¹ý³ÌÃû
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
       ........................
Exception
       ........................
End;
 
£¨2£©´ø²Î
create or replace procedure ´æ´¢¹ý³ÌÃû£¨param1 in type£¬param2 out type£©
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
    Select count(*) into ±äÁ¿1 from ±íA whereÁÐÃû=param1£»
    If (ÅжÏÌõ¼þ) then
       Select ÁÐÃû into ±äÁ¿2 from ±íA whereÁÐÃû=param1£»
       Dbms_output.Put_line(‘´òÓ¡ÐÅÏ¢’);
    Elsif (ÅжÏÌõ¼þ) then
       Dbms_output.Put_line(‘´òÓ¡ÐÅÏ¢’);
    Else
       Raise Òì³£Ãû£¨NO_DATA_FOUND£©;
    End if;
Exception
    When others then
       Rollback;
End;
 
×¢ÒâÊÂÏ
1£¬  ´æ´¢¹ý³Ì²ÎÊý²»´øÈ¡Öµ·¶Î§£¬in±íʾ´«È룬out±íʾÊä³ö
2£¬  ±äÁ¿´øÈ¡Öµ·¶Î§£¬ºóÃæ½Ó·ÖºÅ
3£¬  ÔÚÅжÏÓï¾äÇ°×îºÃÏÈÓÃcount£¨*£©º¯ÊýÅжÏÊÇ·ñ´æÔÚ¸ÃÌõ²Ù×÷¼Ç¼
4£¬  ÓÃselect ¡£¡£¡£into¡£¡£¡£¸ø±äÁ¿¸³Öµ
5£¬  ÔÚ´úÂëÖÐÅ×Òì³£Óà raise+Òì³£Ãû
 
 
ÒÔÃüÃûµÄÒì³£
ÃüÃûµÄϵͳÒì³£                          ²úÉúÔ­Òò
ACCESS_INTO_NULL                   䶨Òå¶ÔÏó
CASE_NOT_FOUND                     CASE ÖÐÈôδ°üº¬ÏàÓ¦µÄ WHEN £¬²¢ÇÒûÓÐÉèÖÃ
ELSE ʱ
COLLECTION_IS_NULL                ¼¯ºÏÔªËØδ³õʼ»¯
CURSER_ALREADY_OPEN          ÓαêÒѾ­´ò¿ª
DUP_VAL_ON_IN