Hi All,
1. How can we start transaction in the begining of PL/SQL program (for eg a porcedure which is doing inserts and updates)? Is it really needed and why?
I am asking this question as someone asked me this in an interview. Though I think that in Oracle its implicit and there is no need or there is nothing like to start transaction in the begining of a procedure. In Oracle, the transaction should start when the procedure executes and performs inserts / update and should complete with a commit (or rollback if a rollback is issued). If a system crashes then it will be rollbacked anyway. So it will be all or none activity. I have not heard of manually or explicitly starting a transaction in the begining of a procedure.
Please let me know.
Thanks for the help.
AKS