Menu
I'm looking for embedded db with Java API for testing purposes. Also i need pl/sql support because we use oracle in production and migrations are written in pl/sql.
I want to test my DAO objects and i need to create db in memory in process of unit test using migration scripts.
Now we use HSQLDB but it does't support pl/sql.
Can you recommend anything?
265
So you need to call a third party REST API from PL/SQL? You'll need to setup your database access control lists (ACLs) to allow it to make external calls first. Then you can call the endpiont using utl_http. You just need to know the URI of the API and it's parameters.
PL/SQL is an embedded language. PL/SQL was not designed to be used as a “standalone” language, but instead to be invoked from within a “host” environment. So, for example, you can run PL/SQL programs from within the database (through, say, the SQL*Plus interface).
The OracleJVM embeds the standard Java namespace in RDBMS schemas. This feature lets Java programs access Java objects stored in Oracle databases and application servers across the enterprise.
Overview of PL/SQL APIs APIs are stored procedures that enable you to insert and update data in Oracle Applications. Additionally, you can use PL/SQL APIs to retrieve data. For example, by using PL/SQL APIs, you can insert a customer record in Oracle Applications.
According to the wikipedia page about PL/SQL, the databases supporting PL/SQL are Oracle and DB2:
If these don't suit you, there's nothing else. PL/SQL is a creation of Oracle, so it's not expected to be widely spread.
173
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
