Database Software

Have a very similar situation, with similar source and target DB versions. Were you able to resolve this issue?

No, I could not resolve the issue (20.4.1.407 does not solve it either so far I can tell)

Thanks for the quick update Dezsoe. I have other tools I can use for this comparison, but was trying to make use of tools provided by the client I am supporting.

can you reproduce this issue if you say...

create user abc121 ...
connect abc123/...
create or replace package do_nothing....
/

then
create user abc19c ...
connect abc19c/...
create or replace package do_nothing....
/

open Compare wizard, with a connection created for both abc123 and abc19c, compare packages - does the error come up?
In other words, I need a test case.
Jeff

Jeff, have not done extensive testing, just hit on this error the 1st object attempted to compare, and the scenario is this.
This worked:
2 Oracle EBS Instances, both running on 12.1.0.2.0, and connecting to both instances as apps. Compare a database package body (ottomint.pkb), and successfully see the results.
What did not work:
Source Oracle EBS Instance running on 12.1.0.2.0, and destination connection is on Oracle EBS 19.0.0.0.0. Again connecting to both instances as apps.
When attempting to compare the same DB object (ottomint.pkb) as described above, receive:

Unable to compare objects.
Ensure that you have the required permissions.
You must own the objects or have select_catalog_role.

I can open this object with the APPS user. As another test, used a different package POR_CUSTOM_PKG, and it worked as expected. Other item to note, there is only 1 difference in the package that did not work between the 2 instances, which is just the version. All code lines match.
/* $Header: ottomint.pkb 120.43.12010000.28 2017/11/20 05:21:54 ramsanth ship $ */
/* $Header: ottomint.pkb 120.58.12020000.16 2017/12/17 10:17:19 ramsanth ship $ */

So you're looing in as APPS in both databases for the compare? If so, sounds like a bug.

Yes, APPS in both instances.

if you have access to My Oracle Support, please file an SR. Be sure to tell them we think it may be APPS/eBiz specific.

I have the same problem
Database diff or cart diff for one package only gives the error:
Unable to compare objects.
Ensure that you have the required permissions.
You must own the objects or have select_catalog_role.
Both databases same 19.5 version

I' ve got such error for only the tables which have xmltype column.

This error seems to happen whenever a package contains this sequence:
?>
Database 19c Standard Edition 2 Release 19.0.0.0.0
SQL Developer 21.4.1.349

Have faced the same Issue. Yes user4381682 is right. This happens when we have xml sample as part of the code. Even if the xml sample is commented, this error comes. Remove all reference to ?> .it should work.

Also detailed in this comment in a parallel thread.
Regards,

[Edited on 21 Feb, 2023: fixed the above link for the new Forums software.]

I am seeing this in SQLDeveloper Version 22.2.1.234.

Its not feasible to remove ?> from all the code.

Is there a solution to this bug?

I'm not sure the bug has ever been logged, as no one opened an SR with a test case as requested in 2021.