Concepts,,,,(සංකල්ප)

In the Production Environment an oracle procedure can lead to Exception or Error which cannot be backtrack if a proper logging machanisam not adopted. Take the following Example Procedure, create or replace PROCEDURE DEPOSIT_INSRT (   APLICTON_ID IN VARCHAR2 , DEP01_ID IN  VARCHAR2 , tempdbexc IN OUT INTEGER ) AS BEGIN --APLICTON_ID:='1383'; --DEP01_ID :='1234567v';   tempdbexc :=1;     INSERT INTO CF_FXD_DEPOSIT ("APPLCTION_ID",  "DEP01_ID",)   VALUES (APLICTON_ID, DEP01_ID);   INSERT INTO CF_FXD_DEP_RECPT ("APPLCTION_ID") VALUES (APLICTON_ID);   DBMS_OUTPUT.put_line('COMMITTED INSERT');   COMMIT; END DEPOSIT_INSRT; In a testing Environment, Example I will use the SQLDeveloper as the web Client to Oracle ,,We can run and verify weather produce is error free for the values given hard corded values i have commented (APLICTON_ID:='1383', DEP01_ID :='1234567v';) However when procedure executi