Monday, January 14, 2013

Rollback when rasise application error?

Do we need to explicitly call rollback when we call RAISE_APPLICATION_ERROR? The answer is: Maybe.

Test case:

CREATE TABLE A (COL1 VARCHAR2(10));

INSERT INTO A VALUES ('1');

begin
    insert into a values('2');
    RAISE_APPLICATION_ERROR(-20005,'ERROR: ');
end;
/

begin
*
ERROR at line 1:
ORA-20005: ERROR:
ORA-06512: at line 4


SQL> select * from a;

COL1
----------
1
 
If we try rollback manually:

begin
    insert into a values('2');
    rollback;
    RAISE_APPLICATION_ERROR(-20005,'ERROR: ');
end;
/
 
begin
*
ERROR at line 1:
ORA-20005: ERROR:
ORA-06512: at line 4
 
SQL> select * from a;
no rows selected
 

Conclusion: RAISE_APPLICATION_ERROR implicits an rollback for the PL/SQL block ONLY. If you want to rollback the whole transaction, you still need to issue rollback explicitly.

1 comment:

  1. F(_)llz avaialable in bulk quantity
    USA UK CANADA all states available

    S_S_N F(_)LLZ
    S_I_N F(_)LLZ
    N_I_N F(_)LLZ
    DL F(_)LLZ

    HERE YOU'LL FIND US

    TG > AT LEADSUPPLIER / AT KILLHACKS
    TG CHANL > t.me/leadsproviderworldwide
    WHT's APP > +1 7.2.7 78.8.6 12.9
    VK MSNGR > AT LEADSUPPLIER

    F(_)LLZ SS.N DOB D.L
    UK N.I.N D.OB Sort Code
    Canada SI.N MM.N Email
    D.L FRONT BACK USA UK CANADA

    MANY LEADS DATABASES AVAILABLE
    CRYPTO & PAYDAY LEADS
    MORTGAGE & LOAN LEADS
    SWEEP STAKES LEADS
    USA EMPLOYEMENT LEADS, PERSONAL INFO LEADS
    UK PHONE NUMBERS & EMAIL LEADS
    CANADA PHONE NUMBER & EMAIL LEADS
    SPECIFIC PROFESSIONALS LEADS
    FACEBOOK, LINKEDIN, AMAZON LEADS
    WORLDWIDE DOMAINS LEADS
    EDUCATION LEADS
    CAR DATABASE LEADS
    W-2 FORMS
    BUSINESS EIN COMPANY LEADS
    HIGH CREDIT SCORES LEADS
    BUSINESS LEADS
    MEDICAL LEADS
    DOCTORS DATABASE LEADS

    #SSN #SSNDOBDL #SellSSN #CCShop #CCSELLCVV #ShopSSNDOBDLADDRESS #FULLZ #SSNFULLZ
    #REALDLSCAN #YoungAgeFullz
    #SIN #SINDOBDL #SellSIN #SINMMNFULLZ #MMNPROSSIN #MMNSIN #CCShop #CCSELLCVV #ShopSINDOBDLADDRESS #FULLZ #SINFULLZ
    #REALDLSCAN #YoungAgeFullz #Fullzseller #CANADAFULLZ #FULLZCANADA
    #NIN #NINDOBDL #SellNIN #CCShop #CCSELLCVV #ShopNINDOBDLADDRESS #FULLZ #NINFULLZ

    ReplyDelete