Posts

Showing posts with the label procedure debug

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