What JUnit-style frameworks are available for unit testing PL/SQL in Oracle?

Question

I'm looking to introduce automated unit testing to a large body of existing Oracle PL/SQL functions, procedures, and types. I would like to use an existing framework that is conceptually as close as possible to JUnit. Free-as-in-beer is required. Apache 2 or similar open source license is a plus. The framework must work in Oracle 10 and 11. Anything that requires changes to the code being tested isn't an option. Active development and strong community support are desired.

What frameworks are available that at least come close to this description?

Have you looked at the suggestions in this question? http://stackoverflow.com/questions/152441/unit-testing-for-pl-sql ? — Ian Carpenter, Apr 28 '11 at 22:31

score 1 · Answer 1 · answered Apr 28 '11 at 21:54

1

One option I have found is PLUTO. I haven't tried it yet, but assuming it is currently functional, it still comes short on a few points:

GPL licensed
No activity for 9 months
No sign of community support

answered Apr 28 '11 at 21:54

Isaac Truett

8,734
1
29
48

score 1 · Answer 2 · answered Apr 29 '11 at 17:08

1

Why not try SQL Developer? You already have Oracle, and this tool doesn't cost you any more. I use Toad myself, but that is a (small) cost.

Check out this link to using it for unit testing

answered Apr 29 '11 at 17:08

tbone

15,107
3
33
40

1

That is an option. However, I would rather not be shackled to SQL Developer. We have some people using SQL Developer now and others using Toad. I use Eclipse as much as possible, personally. I would like a tool that works for all of us, from the command line, and ultimately as part of a Jenkins CI build as well. There is a command-line tool mentioned in your linked article, but I don't know yet how feature-rich it is or how much baggage it would carry. – Isaac Truett Apr 29 '11 at 17:19
well, its put out by Oracle, so any bugs are going to be hammered out (unlike many open source projects which get abandoned). I cant attest to the command line tool, but I would give this serious consideration. – tbone Apr 29 '11 at 18:05

score 0 · Answer 3 · edited May 23 '17 at 12:33

0

See Unit testing for PL/SQL

edited May 23 '17 at 12:33

Community

1
1

answered Apr 29 '11 at 19:55

darreljnz

2,300
2
18
18

That was linked in the question comments as well. The recommendations seemed to be utPLSQL, which is inactive as far as I can tell, and SQL Developer, which I commented on via tbone's answer. I take it this isn't a very active area. – Isaac Truett May 02 '11 at 14:55

What JUnit-style frameworks are available for unit testing PL/SQL in Oracle?

3 Answers3