Page Comparison

Oracle Database User

FDORA_USER

Yes

The username that will be used to connect to the target Oracle Database.

Oracle Database Password

FDORA_PASSWORD

Yes

The password for Oracle Database User.

Oracle Database URL

FDORA_URL

Yes

JDBC URL for Oracle database. For example:

• jdbc:oracle:thin:@HOSTNAME:PORT:SID or

• jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME

Oracle SQLcl Home

FD_SQLCL_HOME

Yes

Folder where SQLcl is installed.

( Ex: /u01/install/sqlcl)

Make sure that the endpoint Java Home is a high enough version for your SQLcl version.

User

FDSQLCL_INP_ORA_USER

No

The username that will be used to connect with. This input takes precedence over the target scoped FDORA_USERproperty. This input is required if the FDORA_USERproperty is not specified.

Password

FDSQLCL_INP_ORA_PASSWORD

No

The password for FDSQLCL_INP_ORA_PASSWORD. This input takes precedence over the target scoped FDORA_PASSWORDproperty. This input is required if the FDORA_PASSWORDproperty is not specified.

Script File

FDSQLCL_INP_FILE_PATH

Yes

Fully qualified or relative path to script file. If relative path is given, it will be assumed to be in the FD_ARTIFACTS_DIR.

User Profile (login.sql)

FDSQLCL_INP_LOGIN_SQL_FILE

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

FDSQLCL_INP_GENERATE_SPOOL_FILE

No

Check to generate report (Spool file) of SQL statement executions.

Show DBMS Output

FDSQLCL_INP_SHOW_DBMS_OUT

No

Print DBMS output in the log.

Fix SQL Syntax

FDSQLCL_INP_FIX_SQL_SYNTAX

No

Check to fix common SQL syntax issues.

Ignore Compilation Warnings

FDSQLCL_INP_IGNORE_WARNING

No

If checked, SQL compilation warnings will be ignored. Otherwise, they will cause the execution to be marked as fail.