Viewing owner name in uppercase when viewing or editing package source

[Stromgol]

When I view or edit a package, the owner name is in lowercase in the generated source.
Example: CREATE OR REPLACE PACKAGE owner_name.PACKAGE_NAME IS

Is there a setting to get the owner name to appear in uppercase instead of lowercase?

Thanks!

 

[Marco Kalter]

There is currently no option for this. I have added this to the list of enhancement requests.

 

[vllr]

Just curious - why would you care about it???

 

[Stromgol]

Why I care about this :
Because when I make a change to a package, I also export the code to a pck file which I check into sourcesafe. Then, when we compare the sourcesafe files to the production database packages, this lowercase owner name comes up as a difference.

It's not a big problem, I just have to make sure I re-type the owner name in uppercase.

However, we are many SQL developers who do this but I'm the only one for whom the owner name exports in lowercase. So I'm thinking there is a setting somewhere, if it's not in PL/SQL Developer, it must be some sort of Oracle session option.

 

[Stromgol]

Ok, we found that this behavior is related to the PL/SQL developer version. I have 8.0.4.1514 installed, people around me running lower versions have the owner name in uppercase.

We tested updating one computer to 8.0.4.1514 and the owner name was now coming out lowercase.

In my opinion, this is a bug.

 

[vllr]

But usually when you compare - you can always have settings to ignore case. Why would you compare with case sensitivity on?

 

[Stromgol]

Like I said, I have workarounds, but this is certainly not an added feature, it's a bug.

If the owner name is uppercase in Oracle, PL/SQL Developer shouldn't change that when it outputs code.

 

[martbrod]

This behavior changed between 8.0.3 and 8.0.4. PL/SQL used to leave the casing intact for the owner and now it's forcing uppercase. In my opinions the product should not temper with the casing... It does not temper with casing in any other part of code for all objects.

Also we use the VCS plugin and since I upgraded it considers all the packages as being different since the owner is uppercase in Source Safe and FORCED to lowercase in PL/SQL...