PL/SQL APIs Use Cases

The PL/SQL API use cases demonstrate how to run the PL/SQL APIs to schedule and run a Build workflow and an Apply workflow.

The use cases are:

• Premise of the PL/SQL Use Cases
  The PL/SQL API use case is built on two predefined workflows, which are available in the SQL Developer installation location.
• Use case to Schedule and Run Apply Workflows
  This use case demonstrates how to run a lineage of the APPLY workflow, which is scheduled to run the WF_RUN_API.
• Use Case to Schedule and Run a Build Workflow
  This use case demonstrates how to run the WF_RUN_API in a lineage of a workflow, poll the status and print node failure from the event log.