> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flexagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# testSuite (utPLSQL)

> Executes utPLSQL test suites using the testSuite operation. utPLSQL version 2.3.1+ only. Target Properties Property Name Property Code Required Descri

Executes utPLSQL test suites using the testSuite operation.  **utPLSQL version 2.3.1+ only.**

# Target Properties

<table><colgroup><col /><col /><col /><col /></colgroup><tbody><tr><th>**Property Name**</th><th>**Property Code**</th><th>**Required**</th><th>**Description**</th></tr><tr><td>utPLSQL Database User</td><td>`FDUTPLSQL_DB_USER`</td><td>Yes</td><td>User used to connect to the associated database.</td></tr><tr><td>utPLSQL Database Password</td><td>`FDUTPLSQL_DB_PASSWORD`</td><td>Yes</td><td>Password for the utPLSQL Database User.</td></tr><tr><td>utPLSQL Database Connection Identifier</td><td>`FDUTPLSQL_DB_CONNECTION_IDENTIFIER`</td><td>Yes</td><td>Identifier used to connect to the Database for utPLSQL testing. Simply the SID can be used if the database is on the same server as the endpoint (e.g. "`xe`" ). If connecting to a server remotely from the endpoint server, the identifier will need to follow the remote connection syntax (e.g. "`(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=localhost)(Port=1521))(CONNECT_DATA=(SID=xe)))`" ).</td></tr><tr><td>utPLSQL Oracle Home Directory</td><td>`FDUTPLSQL_ORACLE_HOME`</td><td>Yes</td><td>Directory for Oracle Home (e.g. "`oracle/product/11.2.0/xe`"), used to run sqlplus.</td></tr></tbody></table>

# Inputs

<table><colgroup><col /><col /><col /><col /></colgroup><tbody><tr><th>**Input Name**</th><th>**Input Code**</th><th>**Required**</th><th>**Description**</th></tr><tr><td>Suite In</td><td>`FDUTPLSQL_TSUITE_INP_SUITE_IN`</td><td>Yes</td><td>The name of the test suite to be tested.</td></tr><tr><td>Recompile In</td><td>`FDUTPLSQL_TSUITE_INP_RECOMPILE_IN`</td><td>No</td><td>Pass `FALSE` if you do not want utPLSQL to automatically recompile your test suite before running the test.</td></tr><tr><td>Reset Results In</td><td>`FDUTPLSQL_TSUITE_INP_RESET_RESULTS_IN`</td><td>No</td><td>Pass `FALSE` to tell utPLSQL to not reset the results information, in which case you will still be able to view results by calling `utResult.show`. Otherwise, utPLSQL clears the result data after each test.</td></tr><tr><td>Per Method Setup In</td><td>`FDUTPLSQL_TSUITE_INP_PER_METHOD_SETUP_IN`</td><td>No</td><td>Pass `TRUE` to run the setup and teardown procedure before and after each unit test procedure is executed. Default of `FALSE` means that these programs will be run once, at the start and end of the suite test execution as a whole.</td></tr><tr><td>Override Package In</td><td>`FDUTPLSQL_TSUITE_INP_OVERRIDE_PACKAGE_IN`</td><td>No</td><td>Override the automatic determination of package names thus removing the one to one relationship between test package and package to test. Default is false. Instead of using this parameter consider using the [runSuite](https://docs.flexagon.com/flexdeploy-10-0-documentation/flexdeploy-plugin-guides/flexdeploy-utplsql-plugin-guide/runsuite-utplsql.md)` operation`.</td></tr></tbody></table>

# Artifacts 

This operation doesn’t consume or produce any artifacts.

# Endpoint Selection

This operation will select all available endpoints associated to the Target.

# Endpoint Execution 

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.