Recompiles all invalid objects in a supplied schema. This operation will only run if invalid objects are found. Operation returns various outputs to indicate invalid object count (before and after) and number of objects recompiled.

Environment/Instance Properties

Property Name	Property Code	Required	Description
JDBC URL	`FDJDBC_URL`	Yes	The JDBC URL of the database.
JDBC User	`FDJDBC_USER`	No	The username that will be used to connect with.
JDBC Password	`FDJDBC_PASSWORD`	No	The password of the username.
JDBC Driver Path	`FDJDBC_DRIVER_PATH`	Yes	Classpath for locating the JDBC Driver (e.g. for WebLogic - `{ORACLE_HOME}/oracle_common/modules/oracle.jdbc_11.2.0/ojdbc6.jar`).

Project Properties

Property Name	Property Code	Required	Description

Inputs

Input Name	Input Code	Required	Description
Schema Name(s)	`FDJDBC_INP_SCHEMA_NAMES`	No	Comma separated list of schema where objects will be compiled.

Outputs

Output Name	Required	Description
`FDJDBC_OUT_PRE_INVALID_CNT`		Invalid object count before execution.
`FDJDBC_OUT_RECOMPILE_COUNT`		Number of objects recompiled.
`FDJDBC_OUT_POST_INVALID_CNT`		Invalid object count after execution.

Artifacts

This operation does not produce or consume artifacts.

Endpoint Selection

This operation will select all available endpoints associated to the environment/instance.

Endpoint Execution

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

compileInvalid (JDBC)