vssandilya

 Profile Answers by vssandilya Questions by vssandilya

• Nov 26th, 2006

 

FOR MULTIPLE TRANSACTIONS TO BE CONTROLLED U NEED TO USE

A TRANSACTION FILE. FOR EXAMPLE A STORES PROGRAM IS THERE.

THERE ARE 50 BOTTLES OF PHYNYLE OF BRAND X OF BATCH NO 99.

SUPPOSE THERE ARE 5 COUNTERS OF  ISSUE.

COUNTER 1  OPENED THE ISSUE SCREEN AND TYPED 4. IMMIDIATELY WHEN THE ENTER KEY IS PRESSED 4 IS ENTERED INTO THE TRANSACTION TABLE

WITH USER CODE. A FLAG  FIELD IS ALSO NECESSARY. FOR EXAMPLE N STANDS FOR NOT COMMITED INTO THE ISSUE TABLE AND D STANDS FOR

COMMITED TO ISSUE TABLE. SO LONG AS THE FLAG REMAINS N IN THE TRANSACTION TABLE TILL THEN

THE FORMULA IS TOTAL STOCK OF BOTTLES OF PHYNYLE OF BRAND X OF BATCH NO 99 -(NO OF BOTTLES OF PHYNYLE IN THE TRANSACTION FILE

OF ALL USERS WHERE THE FIELD FLAG IS N). THIS OUTPUT FLASHES ON

ALL SCREENS WHO WANT TO ISSUE BOTTLES OF PHYNYLE OF BRAND X OF BATCH NO 99.

THE MOMENT THE TRANSACTION IS COMMITED TO THE ISSUE TABLE

STEP -1 SUBTRACT ALL THE TRANSACTIONS FROM STOCK THOSE THAT HAVE BEEN ISSUED USING THE TRANSACTION FILE AND STOCK FILE

STEP -2 CHANGE THE FLAG OF THE TRANSACTION RECORDS OF THAT USER

TO D.

STEP -3 DELETE ALL THOSE RECORDS FROM THE TRANSACTION FILE

WHERE THE FLAG = D AND THE USER CODE = USER CODE OF COUNTER 1.

ALL SHOULD BE DONE USING THE BACKEND  PL/SQL PROGRAMMING.

U NEED TO USE

PACKAGES THAT  USE STORED PROCEDURES FOR DATA ENTRY AND RETRIVAL

AFTER PROCESSING.

THANKS,

V.S.SANDILYA

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

 

use savepoint after each DML statement. If using procedure/function then do not give commit in them. commit in proc/function will erase your savepoints.

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

 

Multiple transaction can be controlled by three ways:

1. COMMIT       : Make changes done in  transaction permanent.
2. ROLLBACK  : Rollbacks the state of database to the last commit point.
3. SAVEPOINT : Use to specify a point in transaction to which later you can rollback

If we do the commit then all savepoints are lost and rollback does not follow for the commited statements.even if rollback is executed after commiting the statements then also statements can't be rollbacked.