Toad World® Forums



I would like to know, if there is a way of testing procedure’s where you
have a “commit” inside, without modifying the repository or if there are
some recomendations or setting’s to solve this problem, because in the case that the
procedure have a “commit” the second test case always fails.




Code Tester will not go inside your source code and change how it works, so if you have a hard-coded commit in your program there is nothing we can do about that.

I suggest, in fact, that you do NOT put any explicit commits or rollbacks in your application code.

Instead, use an encapsulation on TOP of commit; (a procedure that calls the commit for you) so that you can switch off commits while you are testing without having to change your source code.

I have uploaded into the Library the my_commit package, which will help you do what I describe above.

Regards, SF