CODEWITHSUNDEEP
sqliteh2derbyhsqldbin-memory-database
Thiagarajan Ramanathan
Thiagarajan Ramanathan

Reputation: 1124

In memory which supports Oracle "schema.package.function(IN, OUT)"

I have to write JUnit test cases for REST API created using Spring boot and Oracle. There is no dedicated test DB environment. So I planned to use the in-memory database. I did a POC on H2 database. Even after spending 3 days, I was able to do basic things but it is not fully compatible with Oracle. It didn't support In, Out parameter, also it didn't support "call schema.package.function(In, Out)". I was able to create schema and function but I was not able to create a package. Could you please suggest an in-memory which support the following

  1. Should support schema, package and function creation.
  2. Should support In, Out parameter
  3. Should be lightweight
  4. Should be compatible with Oracle and Java

Upvotes: 0

Views: 274

Answers (1)

fredt
fredt

Reputation: 24352

HSQLDB supports IN and OUT parameters for PROCEDURES. You can mimic the schema.package.function(in, out) by renaming the database CATALOG as the name of the schema and creating a separate schema named as the package, then creating the function in that schema.

Alternatively, HyperXtremeSQL (http://hyperxtreme.co.uk) supports creation of package, procedure and function with Oracle syntax.

Upvotes: 2

Related Questions