Print Thread
Viewing owner name in uppercase when viewing or editing package source
#38880 10/19/10 06:06 PM
Joined: Oct 2010
Posts: 11
S
Member
OP Offline
Member
S
Joined: Oct 2010
Posts: 11

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!

Re: Viewing owner name in uppercase when viewing or editing package source
Stromgol #38885 10/20/10 10:20 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
There is currently no option for this. I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Viewing owner name in uppercase when viewing or editing package source
Marco Kalter #38888 10/20/10 02:25 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
Just curious - why would you care about it???

Re: Viewing owner name in uppercase when viewing or editing package source
vllr #38896 10/20/10 07:32 PM
Joined: Oct 2010
Posts: 11
S
Member
OP Offline
Member
S
Joined: Oct 2010
Posts: 11
Why I care about this wink :
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.

Re: Viewing owner name in uppercase when viewing or editing package source
Stromgol #38897 10/20/10 07:49 PM
Joined: Oct 2010
Posts: 11
S
Member
OP Offline
Member
S
Joined: Oct 2010
Posts: 11
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.

Re: Viewing owner name in uppercase when viewing or editing package source
Stromgol #38898 10/20/10 07:50 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
But usually when you compare - you can always have settings to ignore case. Why would you compare with case sensitivity on?

Re: Viewing owner name in uppercase when viewing or editing package source
vllr #38899 10/20/10 08:02 PM
Joined: Oct 2010
Posts: 11
S
Member
OP Offline
Member
S
Joined: Oct 2010
Posts: 11
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.





Last edited by Stromgol; 10/20/10 08:02 PM.
Re: Viewing owner name in uppercase when viewing or editing package source
vllr #38900 10/20/10 08:21 PM
Joined: Oct 2010
Posts: 16
M
Member
Offline
Member
M
Joined: Oct 2010
Posts: 16
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...


Martin Brodeur
Systems Analyst/DBA
Brookfield Renewable Energy Group

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.148s Queries: 14 (0.059s) Memory: 2.5309 MB (Peak: 3.0408 MB) Data Comp: Off Server Time: 2024-05-17 03:03:15 UTC
Valid HTML 5 and Valid CSS