Wednesday, November 24, 2010

Commit in DML Procedure

PROCEDURE armageddon
    IS
    BEGIN
        purge_usr_loan_data_fn(113814);
        commit;
    END armageddon;


Well just a note to myself. If you want your DML changes reflected in the database, issue the command commit =A=

The procedure above calls on another procedure programmed to delete all data I persisted in the database ^^ Having tons of test data could be annoying most of the time, so I need to clean them up once in a while.

No comments:

Post a Comment