Create stored procedures outside GUI

APIs for maintaining Cloud metadata

At the moment, there are no APIs for maintaining the contents of application modules that are addressable for end users. Internally Invantive Cloud uses APIs to register the updates with Data Guard (see Invantive Cloud Structure).

The package cloud_metadata allows some limited access to module logic, which may be executed by retrieving more metadata besides executing.

Deployments

For on-server deployments, it is possible to use Invantive Data Hub or Invantive Query Tool. They can directly access the same and even more data containers as Invantive Cloud.

When it solely concerns development time, the Query Tool can be used to write the module logic.

What type of logic are you planning that it needs to be variable? Or is it for deployment using a pipeline?