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:

Code
get_fund_info(sol_id_in => :APP_ID_NUMBER,
              fund_id_out => :F_FUND_ID,
              fund_name_out => :F_FUND_NAME,
              very_short_name_out => :F_FUND_SHORT_NAME,
              fund_notification_out => :F_FUND_NOTIFICATION);

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

Stew

"That's not a bug, it's a feature?"