PL/SQL Test frameworks -best way to automate PLSQL testing.
672845Nov 27 2008 — edited Mar 25 2009Hi,
I'm looking to find the best way to automate testing of PL/SQL code. The technical aspects of an approach, associated costs involved, etc.
The tools I'm aware of are utPLSQL and Ounit, Quest Code Tester for Oracle, PLUTO and DBUnit.
For the above list of tools or any other ones I would like to know the following information:
- An overview of each tool, in terms of their alliance with xUNIT, background, anything that may be interesting as a selection criteria.
- whether they are based on utPLSQL, or what approach they use if this is useful
- How they might integrate with Junit, as a calling framework.
- Support they provide within tests eg: exception comparisons, resultset comparison, data comparisons, ref cursor support and comparison, dynamic SQL support.
- anecdotal support for usability ie: usage and whether they are problematic
- If open source is there a large community associated, forums etc...
- Anything else that might be useful
Thanks.