[תÔØ]Oracle´æ´¢¹ý³Ìѧϰ

´æ´¢¹ý³Ì´´½¨Óï·¨£º
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_INDEX                  ΨһË÷Òý¶ÔÓ¦µÄÁÐÉÏÓÐÖظ´µÄÖµ
INVALID_CURSOR