Q: Owner of pacakge/prodcedure missing from code

[amihay gonen]

Hi ,
maybe this issue which was discussed in the past (i tried to search but I havn't found)...

When I open code object (package,procedure..) in the editor . It doesn't add the owner name before.

for example create or replace testme ...
instead of create or replace scott.testme...

Is it possible to do have this (may as configurable option).

I need it , because all our install script are running from the same user (admin user).

I know we can use alter session set current schema ...
But this will required more work because we have a lot of schema.

Thanks amihay.

 

[Marco Kalter]

I have added this to the list of enhancement requests. We could consider a preference for this.