Hello @ntubati

The code coverage is a metric that indicates the percentage of code that is executed during a test run.
You can read more about this for example here.

utPLSQL provides line coverage and a block coverage (branches per line of code).
The coverage is calculated at the level of compiled unit of code (package/procedure/function./trigger).

It is not possible to exclude/include individual functions of a single package from a coverage report.

That would also be very much confusing as the percentage of coverage is presented for the whole compiled program unit (package) not for the fragments of that program unit.

I am not sure what is the goal that you are trying to achieve.

In my opinion, since the coverage report says that 2.5% of code is covered with tests, than it is clear that the remaining part is not tested.
This is perfect as it allows you to see the progress of coverage increasing as you write tests to cover the rest of the functionality of the package.

Thanks for the detailed reply. We have never done unit testing cover for PLSQL in our application and we have lot of legacy code. we are planning to start using this and doing a poc. One of the ask is to see how we can calculate the code coverage only for incremental code not for the legacy code. I guess in this case first we have to upload as is code coverage which will show 0 and then look for coverage for incremental code.

Ba based on what you explained , if i have custom package procedure which calls the standard oracle procedure , I can't exclude it from coverage report , but i can exclude it from testing?

You can exclude separate units of compiled code.
So you can exclude packages, standalone procedures and standalone functions.

I suspect that you do not change oracle supplied packages by adding your custom code into their program units.
If you do I would be very concerned.

So you should be able to exclude program units that you do not own and only measure coverage on program units that you own and are responsible for.

I hope this answers your questions.