Compare

[mike]

In development, I can use the APPS user account and our programs are created as APPS.

In production, I can only use my user account for read only. Looking at the objects in the object browser, all objects are prefixed by APPS.

If I open a package in production, right click on the package text, choose "Compare to/Other Database Source..." and choose development, it works great.

If I open a package in development and do the same thing, but compare to production, I get "Source of Package body is not available."

It would be nice to be working in development and compare my program with production. I'm using 32 bit, version 11.0.5.1775.

Thanks,
Mike

 

[Marco Kalter]

Do you see the package body when connected to the production database with your read-only user?

 

[mike]

I can see the source code fine in the production database. In the browser, it is listed like APPS.package_body

I suspect the problem is that when I'm in the development database it is just looking for package_body and not APPS.package_body in production. When I am in production and compare to development, it compares APPS.package_body to package_body.