I am integrating DBUnit for unit testing my application, then I came across the issue of the H2 in-memory DB not supporting PLSQL functions to be specified in the SQL script.
So, can anyhone suggest an in-memory database (alternative to H2) that I could integrate with DBUnit and could execute Oracle PL/SQL functions ?
As mentioned by the second commment, nothing besides Oracle DB will do what Oracle does, in terms of PL/SQL procedures, functions and other features.
So, to use DBUnit, the solution would be a physical Oracle DB that will act just like the H2 in-memory DB. This makes life simple, and works very well.