Trick to Debug Oracle Procedure
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...