Oracle Database Delete

Use this activity to execute an SQL DELETE on Oracle Database connection. The Oracle Database Delete activity returns information in the form of rows affected.

Settings

The Settings tab has the following fields:

Field Description
Oracle Database Connection Name of the Oracle Database connection from which to retrieve information. You can select the connection from the Oracle Database Connection list.

Input Settings

The Input Settings tab has the following fields:

Field Description
Delete Statement An SQL statement used to delete records from a table. You construct prepared SQL queries by using substitution variables (or parameters) of the form ? in the delete statement. Each substitution variable identifies an input parameter whose mapped value will be substituted in the substitution variable at runtime. User can reuse the substitution variable for the same input parameter elsewhere in the delete query.

The type information for the input parameters used in the WHERE clause is fetched from the database using the selected Oracle Database connection for the entered delete query. Input and output fields in the Input and Output tabs of the activity are also populated based on the SQL DELETE statement.

Be sure to include the semicolon (;) at the end of the query. This activity expects a query to end with a semicolon to indicate the end of the query. A missing semicolon at the end of the query results in the query hanging.

Examples of DELETE query: 

  • DELETE from employee where name = ?name;
    For the above delete query, output field is generated for id (NUMBER) from the returning clause and input field is generated for name (VARCHAR). Also the mapped value for the field name is substituted into the substitution variable ?name. 
  • Delete from employee;
    For above delete query, no output and input would be generated, as where clause is not present.
Manually Configure Metadata When schema retrieval fails due to non standard SQL, use Manually Configure Metadata. For more information, see Using Manually Configure Metadata Option.
Table Schema Displays the metadata of the SQL delete statement. You can modify the column metadata if Manually Configure Metadata is set to True.
Note: If you modify the metadata, ensure that it is in agreement with the query added.

Input

The Input tab displays the input schema of the activity as a tree structure. The schema varies according to the object that you selected on the Input Settings tab. You can provide the input values in the Flogo Connector for mapping input fields directly or use Mapper to map the input values to a field from the output of a preceding activity in the flow.

Output

The Output tab displays the output schema of the activity as a tree structure. The output is read-only. The properties that are displayed in the schema correspond to the output of this activity and can be used as input by subsequent activities in the flow.