Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Input Name

Input Code

Required

Description

User

FDSQLPLUS_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

FDSQLPLUS_INP_ORA_PASSWORD

No

The password for FDSQLPLUS_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

FDSQLPLUS_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)

FDSQLPLUS_INP_LOGIN_SQL_FILE

No

User Profile (login.sql) is intended to allow users to specifically customize their session.

(see the Special considerations Considerations section for examples)

Generate SQL Spool File

FDSQLPLUS_INP_GENERATE_SPOOL_FILE

No

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

Show DBMS Output

FDSQLPLUS_INP_SHOW_DBMS_OUT

No

Print DBMS output in the log.

Fix SQL Syntax

FDSQLPLUS_INP_FIX_SQL_SYNTAX

No

Check to fix common SQL syntax issues.

Ignore Compilation Warnings

FDSQLPLUS_INP_IGNORE_WARNING

No

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

...