Over the past few years of developing open source PL/SQL tools I’ve learned that one of the key things to make a project successful is have a frictionless install process. Node.js does this very well with their Node Package Manager (
npm). Currently there is no largely adopted solution like
npm for Oracle tools so one must usually provide a downloadable zip file containing the code along with installation instructions.
The above script is a very simple one:
prompt hello from github which can be adapted to contain a full install process.
The nice thing about running remote SQL scripts is that no ACL settings are required on the server nor SSL certificates since the client (i.e. your machine) is making the web request. The bad thing about this is that it opens the door for a lot of vulnerability potentials. It’s recommended to always review the script before running it.