Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

banking system

441475Aug 17 2005 — edited Nov 2 2005
i am working on a banking system ,where i am implementing the function of taking money from one account and add it to another account so i write a procedure to do the following:
1 update the first account(reduce x)
2 update the second account(add x)
so what is the safest way to call that procedure???
( i call it from when-button-press trigger then i do commit to make sure that the two actions were completed before doing commit)

transfer(:value);
commit;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2005
Added on Aug 17 2005
15 comments
861 views