test (utPLSQL)

Executes individual utPLSQL test packages using the test operation.  utPLSQL version 2.3.1+ only.


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

Package InFDUTPLSQL_TEST_INP_PACKAGE_INYes

The name of the package or stand-alone program to be tested.

*If utPLSQL Database User is not the test package owner, do not schema-qualify the package. Instead, place the schema name in the Owner In parameter.

Recompile InFDUTPLSQL_TEST_INP_RECOMPILE_INNoPass FALSE if you do not want utPLSQL to automatically recompile your test package before running the test.
Same Package InFDUTPLSQL_TEST_INP_SAMEPACKAGE_INNoPass TRUE if your unit test programs are defined in the same package as the source code to be tested. The default is that you have created a separate package.
Prefix InFDUTPLSQL_TEST_INP_PREFIX_INNoThe prefix to be appended to package_in to come up with the name of the test package. If you do not provide a value, the last prefix you specified (or the default) will be used.
Directory InFDUTPLSQL_TEST_INP_DIR_INNo

The directory containing the test package source code. If you do not provide a value in your call to utPLSQL.test (the default) and if you have not turned off automatic recompilation, utPLSQL will look for the test package source code in the directory specified by a call to utConfig.setdir. If you do not provide a value, the last directory youspecified (if any) will be used.

Suite InFDUTPLSQL_TEST_INP_SUITE_INNoThe name of the suite that contains the specified test package. This is an optional value and is used to update statistics for the test.
Owner InFDUTPLSQL_TEST_INP_OWNER_INNo

The name of the schema that contains the packages to be tested.

Reset Results InFDUTPLSQL_TEST_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.

From Suite InFDUTPLSQL_TEST_INP_FROM_SUITE_INNoPass TRUE to tell utPLSQL that this test is being run from within a test suite (for internal use only).
Subprogram InFDUTPLSQL_TEST_INP_SUBPROGRAM_INNoPass a string to restrict which of the test procedures will be executed for this run. Default of '%' means all tests will be run.
Per Method Setup InFDUTPLSQL_TEST_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 package test execution as a whole.

Override Package InFDUTPLSQL_TEST_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 NULL. Instead of using this parameter consider using the run 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.