I’m currently working on an old app which is supported by an Oracle database, this app uses a lot of PL/SQL scripts to store procedures in packages, to create users, tables and execute queries. The app connect to the DB and load all the procedures with PL/SQL requests, in the same time, it also create users to be able to delimitate work. Once done, we just use the procedures stored in the DB to do manipulation on the data.
I’m looking if it’s possible to make this app works in a different database (PostgreSQL) but with only writing one main generic code.