Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Executes a SQL script file.Property replacement is performed on the files before they are executed.

Delimiting Sql files

Please note that the statements in the Sql files must be delimited properly.

  • Use ; to delimit individual statements.

  • Use / on new line to delimit program blocks.

  • Use /* or -- (two dashes) for comments.

Target Properties

Property Name

Property Code

Required

Description

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.

SQLPlus Path

FDSQLPLUS_PATH

No

Provide the sqlplus path (Required if sqlplus is not on PATH environment).

( Ex: /u01/install/APPS/apps/tech_st/10.1.2/bin/sqlplus)

SQLPlus Source Script

FDSQLPLUS_ENVIRONMENT_SCRIPT

No

Source Script with full path.

(Ex: /u01/install/APPS/apps/apps_st/appl/oracle_config.env)

Oracle SID

FDSQLPLUS_ORACLE_SID

No

Provide the Oracle SID (optional if it is already set in the source script).

Inputs

Input Name

Input Code

Required

Description

User

FDSQLPLUS_INP_ORA_USER

No

The username that will be used for database connection. This input takes precedence over the Target ORA User property.

Password

FDSQLPLUS_INP_ORA_PASSWORD

No

Password for User specified in plugin input. This input takes precedence over the Target ORA Password property.

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.

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

Artifacts

This operation consumes one Sql file from the artifacts repository.

Endpoint Selection

This operation delegates the selection to the workflow developer to determine.

Endpoint Execution

This operation will randomly execute on one of the endpoint identified during selection.

  • No labels