Skip to Main Content

SQL Developer

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!

Different results of unit test with ututil and GUI

792537Aug 19 2010 — edited Dec 7 2010
I discovered strange behaviour of ututil utility. I made a simple example, which shows my problem:

Table A with column AA includes one row with the value 222.

Function AAA source code:
-------------
create or replace
PROCEDURE AAA AS
BEGIN
NULL;
END AAA;

Test suite AS, which contains AAA test and its tearup is:
-------------
BEGIN
delete from a;
commit;
END;

Test AAA:
-------------
Tearup:
BEGIN
insert into a (aa) values ('222');
END;
-------------
Teardown:
BEGIN
ROLLBACK;
END;

Table A should be empty after this testsuite. If I run this testsuite from GUI and from commandline (ututil) I become different results.
After GUI-run is table clear, but after ututil-run is table still with row 222. (SQL Developer 2.1.1.64 build MAN-64.45)

Ututil-run: ututil -run -suite -name AS -repo TEST

Thanks for any help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2011
Added on Aug 19 2010
1 comment
848 views