Help to select a Unit testing tool for database

[komal sharma]

hi,

1)
i want a Unit test tool to test my stored procedure. my database is in oracle.
i hav already tried:
DBunit --- doesnt help that much in testing procedure,
SQLUnit--- the assert available are not helping me,
anydbtest--- is not a open source

can anyone help me find a tool that you have experienced and works fine with oracle.
my basic requirement is to test procedure and assert if it returns result i dont need to match exact data.

2) any one familier with SQLUnit ?? i wanted to know if we can assert the result set just to check if its null or not null???

[Ulf Dittmer]

Does "anydbtest" do what you need to do? If so, I'd suggest to go with it. Its license cost plus a year's worth of support is so low (especially considering that you're using an Oracle DB which costs serious money), that it would only take a few hours worth of your time investigating other tools to make it a superior choice.

[komal sharma]

ya true that was my first choice but i was told not to increase the cost n asked to find an open source tool. so i hav to work wit the available tools.. do you hav any knowledge abt SQLUnit