Category : Files from Magazines
Archive   : DBMS9003.ZIP
Filename : EDELSTN2.MAR

Listing 2:

char *uid = "tp1/tp1"; /* ORACLE userid */
long account_no; /* transaction variables */
int branch_no;
int teller_no;
int amount = 1;
char *info = "12345678"; /* for HISTORY table */

char *stmt0 = "UPDATE account \
SET balance = balance + :amount \
WHERE account = :account_no";
char *stmt1 = "UPDATE branch \
SET balance = balance + :amount \
WHERE branch = :branch_no";
char *stmt2 = "UPDATE teller \
SET balance = balance + :amount \
WHERE teller = :teller_no";
char *stmt3 = "INSERT INTO history \
VALUES (:account_no, :teller_no, :branch_no, \
:amount, :info, SYSDATE)";
char *stmt4 = "COMMIT";