3 ms·

You can load Java Classes into Oracle DB and run them natively inside the server. Those classes can call stored procedures or functions. Those classes can be

by csours 1y ago

You can load Java Classes into Oracle DB and run them natively inside the server. Those classes can call stored procedures or functions. Those classes can be called BY stored procedures or functions. You can call stored procedures and functions from server-side Java code. So you can have a java app call a stored proc call a java class call a stored proc ... Yes. Yes, this is why they call it Legacy.

mdaniel 1y ago
That's ok, modern nodejs apps are represented, too, so everyone can get in on the legacy train: https://docs.oracle.com/en/database/oracle/oracle-database/23/mlejs/using-javascript-modules-mle.html#GUID-0E40C6C1-3458-40EB-A81C-DC11885C2D24 https://docs.oracle.com/en/database/oracle/oracle-database/2... and https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.17:~:text=plv8 https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQ... or, if the modern job postings are indicative, FastAPI to PG to PY https://www.postgresql.org/docs/17/plpython-funcs.html https://www.postgresql.org/docs/17/plpython-funcs.html