Code completion fails on case for constants in double quotes

[Clever Idea Consulting]

I am using the latest 7.0.1.1066 build / 10gR2 server(win32) / 9iR2 client bins

The code completion returns the double quotes, but it is always in all lower case between the quotes.

For example:

PackageA spec has defined:

"MyConstant" constant varchar2(10) := 'whatever';

When typing code for PackageB's body, when I type PackageA. (and pause) I get "myconstant" in the code completion window and if I select it, it returns exactly "myconstant" which of course isn't a valid identifier.

Does PL/SQL Developer specifically NOT support double-quoted identifiers or is this a bug? This is a fairly large problem for me.

Thanks,
Michael O'Neill
Clever Idea Consulting

 

[Claus Pedersen]

PLD seems to have problems with single quotes in packages as well.

Try to view the package header SYS.standard

All names enclosed in single quotes are listed as 'function' in the content browser, e.g. function 'NOT'.

But as you state, code completion always returns double quoted names in lower case.

 

[rbrooker]

what do you have your keyword case set to?

In preferences, User Interface -> Editor, there is an option for Keyword Case, make sure it is set to "Unchanged", not "Lowercase".

You may also have this option in your beautifier set to "Lowercase", General tab, Syntax Case group ( on RHS ), Keyword and Identifier case.

 

[Clever Idea Consulting]

Good idea Claus. I checked it out and it had no effect. No matter the Editor setting, it comes back all lower case inside the double quotes.

It's definitely not a beatifier thing, either, as it does (and always should) ignore text literals in both single and double quotes.

So, can this be added to the buglist? It seems to me to be a core failure for a commercial PL/SQL IDE to fail on code completion of legally coded identifiers. Plus, I'm whining real real hard. Thanks.

 

[Marco Kalter]

We'll check it out and will try to fix it.

 

[Clever Idea Consulting]

That would be great! Thank you so much.