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
COL1
----------
1
If we try rollback manually:
begin
insert into a values('2');
rollback;
RAISE_APPLICATION_ERROR(-20005,'ERROR: ');
end;
/
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
*
ERROR at line 1:
ORA-20005: ERROR:
ORA-06512: at line 4
SQL> select * from a;
no rows selected
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.
F(_)llz avaialable in bulk quantity
ReplyDeleteUSA 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