o8if 0201
Main Transaction (MT)
Procedurę add emp{...)
IS
BEGIN
UPDATE ...
UPDATE ...;
SAVEPOINT start_add; INSERT . . . ;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK to start_add;
write-log { -
SQLCODE, SOLERRM);
END;
Autonomous Transaction (AT)
PROCEDURĘ write_log{...)
IS
PRAGMA
AUTONOMOU S_TRANSACTION
BEGIN
INSERT INTO log -
VALUES < \ ATbegins
codę, text,
USER, SYSDATB
>;
COMMIT:
END;
|
MT ends |
_/r | |
|
MT resumes | ||
Wyszukiwarka
Podobne podstrony:
sql2 0806 PROCEDURĘ early_failure IS BEGIN DEC LARATION little_string VARCHAR2(2) := BIG STRING ; B
sql2 0806 PROCEDURĘ early_failure IS BEGIN DEC LARATION little_string VARCHAR2(2) := BIG STRING ; B
sql2 1505 PROCEDURĘ get_happy IS BEGIN DECLARE hiredate DATĘ; BEGIN END; END get_happy;
is the one that is the ultimate recipient of said transaction or procedurę. Sometimes the originatin
80583 symbols hazmat signs Fireon skin fopouiinhaledSpillaye The Main HazardsFLAMMABLE, TOXICEMERGEN
PODSTAWOWE ASPEICTY BEZPIECZEŃSTWA INFORMACJI 8) Transakcja: a) Operacja (procedur
admin main Current Vote or Add Polis W YotelD Subject: 84129 PetNames 65014 Best Drinking College&nb
img171 171 12.1. Parsing ekspansywnych języków grafowych procedurę ExpRec (var rec); begin for i :=
img171 171 12.1. Parsing ekspansywnych języków grafowych procedurę ExpRec (var rec); begin for i :=
sql2 1507 PROCEDURĘ update_management (company_id_in IN NUMBER) IS BEGIN BEGIN ____ UPDATE employee
2 12 2 Three stages of negotiation Next Slide i !► * The main objective of the mid
htdctmw 016 One of the main things that can ruin a drawing is the appearance of FLATNESS. Too many b
Open interfaces of GSMOpen interfaces of GSM One of the main purposes behind the GSM specifications
89 TransAlp Manual Fuel System 4 2 FUEL SYSTEMTROUBLESHOOTING Engine cranks but won t start •
tekst2 THE MAIN SCHOOL OF FIRE SERYICE MSFS is the only one in Poland and one of the few State techn
więcej podobnych podstron