...
Please note that the statements in the SQL files must be delimited properly.
Target Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Oracle Database User |
| Yes | The username that will be used to connect to the target Oracle Database. |
Oracle Database Password |
| Yes | The password for Oracle Database User. |
Oracle Database URL |
| Yes | JDBC URL for Oracle database. For example:
|
Oracle SQLcl Home |
| Yes | Folder where SQLcl is installed. Make sure that the endpoint Java Home is a high enough version for your SQLcl version. |
Project Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
SQL Extension Order |
| No | List SQL file extensions in desired order. Will be used for discover and sort. Files with these extensions will discover as type DB Object. |
SQL Retry Count Default |
| No | When discovering or evaluating files, default the Retry Count to this. |
Stop On Deployment Error |
| No | Stop deploying package files if any error occurs. If unchecked all files will be deployed even if one or more files fails. This is for package operations only. |
SQL Ignore Compile Warning Extensions |
| No | When discovering or evaluating files, set the Ignore SQL Compilation Warning attribute to true for files with these extensions. |
SQL Property Replacement Default |
| No | When discovering or evaluating files, default Property Replacement to this. |
SQL Root Target Folder |
| No | The path to store the delivered Sql files. Sql files will be run from here. Leave blank to run them from the |
Other Root Target Folder |
| No | The path to store the delivered Other files. Leave blank to store them in the |
Inputs
Input Name | Input Code | Required | Description |
---|---|---|---|
User Profile (login.sql) |
| No | User Profile (login.sql) is intended to allow users to specifically customize their session. (see the Special considerations section for examples) |
Generate SQL Spool File |
| No | Check to generate report (Spool file) of SQL statement executions. |
Show DBMS Output |
| No | Check to print DBMS output in the log. |
Artifacts
This operation consumes packages of files created by the packageBuild(SQLcl) operation.
...