Stored Procedure DBUnit

[TK Ganesh]

I would like to create dataset based on the stored procedure and insert the same into new database. Is it possible to do this using DBUnit?

[Lasse Koskela]

Could you be more explicit about what you mean by creating a "dataset from a stored procedure" and what you mean by "new database"?

[TK Ganesh]

I have a stored procedure which contains complex sql statements. Also i have a test db which i have newly created for testing my stored procedure. Since this is empty database, i want to create tables and put test records for the tables that are used in stored procedure. If i do this manually, it is very difficult to find out how many tables and i may miss out something because stored procedure uses lots of inner procedures and lot of joins. I want to know whether DBUnit can read my stored procedure and store the various datasets in flat xml file?