I work in Oracle Application Express (aka Apex) a lot and I regularly copy anonymous blocks from there into PSD for editing (then paste them back).

Apex's "variables" (aka Page Items and Application Items) need to be referenced in the format:

:UPPERCASE_VARIABLE_NAME

like:


In the Beautifier Use Special Case documentation, it says you can reference an item with a wildcard, like DBA_% to uppercase everything that starts with "DBA_".

I'd like to do the same with an "word" that's immediately preceded by a colon.

But that doesn't seem to work, but instead sets the Apex variable to lowercase. I don't know if it's a limit on how short the "word" can be or it's ignoring the colon or what.

Is there a particular syntax I could use for this? Maybe a regex? If not, could you please add this wish to your list?

Thanks,

Stew

I have added this to the list of enhancement requests.

Hi Stew,

Are you sure the bind variables in APEX are case sensitive? as far as I can see they are not.
When using bind variable syntax, remember the following rules:
Bind variable names must correspond to an item name.
Bind variable names are not case-sensitive.
Bind variable names cannot be longer than 30 characters (that is, they must be a valid Oracle identifier).

@koja

Thanks for the thought. I just tested referencing a page item using lowercase name and the returned value is null.

That's what I'd always known as the rule. It would have been frustrating if I'd been careful to do that all these years and it hadn't been true! ;-)

I stand corrected (and greatly embarrassed). I don't know what my original test was, but it was clearly flawed.

I re-tested and found that @koja and the documentation are correct. The bind variables are case-insensitive and I've been doing extra work for decades!

It doesn't explain my bad test, but I suspect I made up this "rule" in my head because the Apex documentation always shows UPPERCASE bind variables.

@Marco - Please remove my request from the enhancement requests list.