PL/SQL APIs

You can use the PL/SQL APIs to manage projects and workflows.

Use the PL/SQL APIs to perform the following tasks:

• PROJECT_CREATE
  The function PROJECT_CREATE creates a project using the project name that you provide. The function returns a project ID. If the project already exists, the function raises an exception.
• PROJECT_RENAME
  The PROJECT_RENAME procedure renames an existing project. If a project with the new name already exists, then the procedure raises an exception.
• PROJECT_DELETE
  The procedure PROJECT_DELETE enables you to delete one or more projects along with the workflows contained in it. If any workflow is running or is opened by Oracle Data Miner, then the procedure raises an exception.
• WF_RUN
  The function WF_RUN that runs a workflow contains signatures that accepts names, project IDs, workflow and specific nodes to run.
• WF_STOP
  The procedure WF_STOP enables you to stop or cancel a workflow that is scheduled to run. If the workflow is not already running or scheduled, then the procedure raises an exception.
• WF_RENAME
  The procedure WF_RENAME renames an existing workflow.
• WF_DELETE
  The procedure WF_DELETE deletes a workflow along with all the generated objects such as tables, views, models, test results, and so on. If the workflow is either already running or opened by the Oracle Data Miner, then it raises an exception.
• WF_IMPORT
  The WF_IMPORT function imports a workflow (exported by the Oracle Data Miner) to the specified project. Since the workflow is backward compatible, you can import an older version of a workflow to a newer Oracle Data Miner Repository.
• WF_EXPORT
  The WF_EXPORT function exports a specified workflow. If the workflow is either already running or opened by the Oracle Data Miner, then it raises an exception. Alternatively, you can query the ODMR_USER_PROJECT_WORKFLOW for workflows to export.