4 Replies Latest reply on Mar 15, 2018 9:17 AM by Narmada T

Sql Developer Unit Test- Gather Code Coverage Statistics

Narmada T Mar 9, 2018 7:12 AM

I am using Sql Developer Unit Test framework to create unit test cases and test suites for my development. I was able to successfully create the repository , run the test cases and able to see the reports. Only problem i am facing is with Gather Code coverage Statistics.

When i check this check box and run the test case it should ideally gather the stats and populate UT_TEST_COVERAGE_STATS table and also the reports "Suite Runs Code Coverage" and "Test Runs Code Coverage" should show up the statistics of my test cases and test suites. But all these are blank. There is no data in UT_TEST_COVERAGE_STATS table. Also there is no error while running the tests and the results tab of test case/test suite shows the details like Coverage Run On - 'Date'. I want to know if i am missing any permissions to run the stats or any additional setup is required to get the coverage statistics.

1. Re: Sql Developer Unit Test- Gather Code Coverage Statistics

thatJeffSmith-Oracle Mar 9, 2018 2:47 PM (in response to Narmada T)

We use the pl/sql profiler to get code coverage stats. Try observing the sql going across the wire in the View > Log > Statements panel for insight for what might be going wrong in your scenario.
Like Show 0 Likes(0)

Actions
2. Re: Sql Developer Unit Test- Gather Code Coverage Statistics

Narmada T Mar 14, 2018 11:09 AM (in response to thatJeffSmith-Oracle)

Thank you so much for your response JeffSmith. Here is the error I could see in log
Error : "java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
" building UT_TEST_COVERAGE_STATS_PK, executing sql:
SELECT /*OracleDictionaryQueries.ALL_INDEX_METADATA_QUERY*/
SYS.DBMS_METADATA.GET_XML('INDEX', ?, ?) XML
FROM SYS.DUAL
Like Show 0 Likes(0)

Actions
3. Re: Sql Developer Unit Test- Gather Code Coverage Statistics

thatJeffSmith-Oracle Mar 14, 2018 12:37 PM (in response to Narmada T)

I would open a service request with My Oracle Support - include those details. Also, be sure to tell them your version of oracle DB.
Like Show 0 Likes(0)

Actions
4. Re: Sql Developer Unit Test- Gather Code Coverage Statistics

Narmada T Mar 15, 2018 9:17 AM (in response to thatJeffSmith-Oracle)

I think the issue here is access/privileges to run this query
SELECT /*OracleDictionaryQueries.ALL_INDEX_METADATA_QUERY*/
SYS.DBMS_METADATA.GET_XML('INDEX', ?, ?) XML
FROM SYS.DUAL.

SYS.DBMS_METADATA.GET_XML requires SELECT_CATALOGUE role. When i run this query alone SELECT DBMS_METADATA.GET_XML('TABLE','EMP','SCOTT')FROM DUAL; on my Unit Test Repo schema, i get Invalid Identifier error.
The same query on schema that has select_Catalogue role runs successfully and returns the xml. So i have to try giving SELECT_CATALOGUE role to Unit test repo schema and try to gather statistics to test if that works.
Like Show 0 Likes(0)

Actions

Go to original post