utPLSQL Database User

FDUTPLSQL_DB_USER

Yes

User used to connect to the associated database.

utPLSQL Database Password

FDUTPLSQL_DB_PASSWORD

Yes

Password for the utPLSQL Database User.

utPLSQL Database Connection Identifier

FDUTPLSQL_DB_CONNECTION_IDENTIFIER

Yes

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)))" ).

utPLSQL Oracle Home Directory

FDUTPLSQL_ORACLE_HOME

Yes

Directory for Oracle Home (e.g. "oracle/product/11.2.0/xe"), used to run sqlplus.

Suite In

FDUTPLSQL_RSUITE_INP_SUITE_IN

Yes

The name of the test suite to run.

Autocompile On

FDUTPLSQL_RSUITE_INP_AUTOCOMPILE_ON

No

Pass FALSE to avoid auto-recompilation for the runSuite operation. The default settings for utPLSQL is to re-compile your base package before each unit test.

Reset Results In

FDUTPLSQL_RSUITE_INP_RESET_RESULTS_IN

No

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.

Per Method Setup In

FDUTPLSQL_RSUITE_INP_PER_METHOD_SETUP_IN

No

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 test suite execution as a whole.