Hi,
I am trying to create unit tests for a procedure of a package using the Unit Test tool of SQL Developer. I am able to create the unit test and also successfully test the case. But I am not getting any output of the code coverage for the test case even though I have checked the check box "Generate Code Coverage Statistics".
I can see the below records in the underlying tables of unit testing and the code coverage stats table is populating with a error message "ORA-00955: name is already used by an existing object ORA-06512: at line 10". Below are the records of the corresponding tables.
UT_TEST_RESULTS:
| UTR_ID | UT_ID | NAME | STATUS | MESSAGE | COVERAGE | TEST_USER_NAME | CONNECTION_NAME | RUN_DATE | CREATED_ON | CREATED_BY | UPDATED_ON | UPDATED_BY |
| 3aabd27a-469d-4cec-96e0-f61feb1c2275 | c105e96e-8a35-47ed-a07f-b7e68fd79b36 | TEST CASE1 | UT_SUCCESS | | 1 | XXXX | XXXX@XXYZ | 14-DEC-16 02.52.01.420257000 PM | 14-DEC-16 04.22.01.000000000 AM | XXXX | 14-DEC-16 04.22.01.000000000 AM | XXXX |
UT_TEST_IMPL_RESULTS:
| UTIR_ID | UTI_ID | UTR_ID | NAME | STATUS | MESSAGE | START_TIME | END_TIME | DURATION | STARTUP_STATUS | STARTUP_MESSAGE | STARTUP_START_TME | STARTUP_END_TIME | STARTUP_DURATION | OP_CALL_STATUS | OP_CALL_MESSAGE | OP_CALL_START_TIME | OP_CALL_END_TIME | OP_CALL_DURATION | TEARDOWN_STATUS | TEARDOWN_MESSAGE | TEARDOWN_START_TIME | TEARDOWN_END_TIME | TEARDOWN_DURATION | RUN_DATE | CREATED_ON | CREATED_BY | UPDATED_ON | UPDATED_BY |
| 1efdedd7-26fa-4c5b-8d8f-6e4a36d94c89 | 70448789-7ea7-48d1-b844-156661d18364 | 3aabd27a-469d-4cec-96e0-f61feb1c2275 | Test Implementation 1 | UT_SUCCESS | | | 14-12-2016 14:53:45 | 101264 | UT_SUCCESS | | | 14-12-2016 14:52:08 | 5020 | UT_SUCCESS | | | 14-12-2016 14:53:09 | 16165 | UT_SUCCESS | | | 14-12-2016 14:53:44 | 29964 | 14-DEC-16 02.52.03.542679000 PM | 14-DEC-16 04.22.03.000000000 AM | XXXX | 14-DEC-16 04.22.03.000000000 AM | XXXX |
UT_TEST_COVERAGE_STATS:
| UTC_ID | UTIR_ID | UTI_ID | UNIT_OWNER | UNIT_NAME | LINE | TOTAL_OCCUR | TOTAL_TIME | TEXT | CREATED_ON | CREATED_BY | UPDATED_ON | UPDATED_BY |
| 889150ee-dde1-46cc-af81-ea3ba320f4f2 | 1efdedd7-26fa-4c5b-8d8f-6e4a36d94c89 | 70448789-7ea7-48d1-b844-156661d18364 | | | -1 | -1 | -1 | ORA-00955: name is already used by an existing object
ORA-06512: at line 10
| 14-DEC-16 04.23.48.000000000 AM | XXXX | 14-DEC-16 04.23.48.000000000 AM | XXXX |
Please help me out to resolve this issue.
Thanks.