Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL Test frameworks -best way to automate PLSQL testing.

672845Nov 27 2008 — edited Mar 25 2009
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2009
Added on Nov 27 2008
9 comments
1,808 views