testSuite (utPLSQL)

Executes utPLSQL test suites using the testSuite operation.

Environment/Instance Properties

Property Name

Property Code

Required

Description

utPLSQL Database UserFDUTPLSQL_DB_USER

Yes

User used to connect to the associated database.
utPLSQL Database PasswordFDUTPLSQL_DB_PASSWORDYesPassword for the utPLSQL Database User.
utPLSQL Database Connection IdentifierFDUTPLSQL_DB_CONNECTION_IDENTIFIERYesIdentifier 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 DirectoryFDUTPLSQL_ORACLE_HOMEYesDirectory for Oracle Home (e.g. "oracle/product/11.2.0/xe"), used to run sqlplus.

Inputs

Input Name

Input Code

Required

Description

Suite InFDUTPLSQL_TSUITE_INP_SUITE_INYesThe name of the test suite to be tested.
Recompile InFDUTPLSQL_TSUITE_INP_RECOMPILE_INNoPass FALSE if you do not want utPLSQL to automatically recompile your test suite before running the test.
Reset Results InFDUTPLSQL_TSUITE_INP_RESET_RESULTS_INNo

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 InFDUTPLSQL_TSUITE_INP_PER_METHOD_SETUP_INNo

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.

Override Package InFDUTPLSQL_TSUITE_INP_OVERRIDE_PACKAGE_INNo

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 operation.

Artifacts 

This operation doesn’t consume or produce any artifacts.

Endpoint Selection

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

Endpoint Execution 

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

The following macros are not currently supported in the footer:
  • style