Toad World® Forums

Named parameters in PL/SQL are "fragile"


#1

Hi TOAD Community,

I really like TOAD 12 x64 after having to use the old 32-Bit Version 9.6 for 8-9 years My employee at least decided to upgrade to 12.12. Very good! After using it for some time, I must say it’s really OK, but of course there are still some flaws, so Quest (Dell?) developers have some work to do [:D]

With Intellisense I like to use named notation for PL/SQL procedure/function calls. So I often use intellisense to pick a procedure from a package, and after I provide the “open” parantheses ‘(’, TOAD presents the available signatures to be browsed. I select one and let Toad fill in the prototype, like shown below, TOAD will automatically select the first param (“State 1” below, selection is shown in bold on yellow). Since I hate UPPERCASE text except for symbolic constants, I try and select all uppercase text and hit CTRL+L to “lower” it. But this will destroy nearly the whole line, leaving only half of the the first argument intact, like shown in this three :

State I: After selecting the prototype, TOAD has selected the 1st argument (bold on yellow background)

begin
utility_package.get_view_def(P_VIEW_NAME => P_VIEW_NAME IN VARCHAR2, P_VIEW_DEF => P_VIEW_DEF OUT CLOB, P_VERBOSE => P_VERBOSE IN BOOLEAN)
end;
/

State II: I extend selection in order to press CTRL-L afterwards, selection is again shown bold on yellow:

begin
utility_package.get_view_def(P_VIEW_NAME => P_VIEW_NAME IN VARCHAR2, P_VIEW_DEF => P_VIEW_DEF OUT CLOB, P_VERBOSE => P_VERBOSE IN BOOLEAN)
end;
/

State III: After I hit CTR+L, this is what is left; everything following the first “=>” is gone. Too bad!

begin
utility_package.get_view_def(p_view_name =>[CURSOR positioned here]
end;
/

Of course I have checked the TOAD config options “Use lowercase characters after selecting elements from intellisense” as one of my fist configuration steps, since - like I said before - I HATE UPPERCASE letters crying at me.

I expected this “use lowercase” option to be honoured for named notation also, but it isn’t…

Question 1: Is the “fragility” shown above a known problem with TOAD 12, or is there something I’m doing wrong?

Question 2: In future versions, will there be a lowercase option available for named notation prototypes ?

Thanks in advance for your opinions and tips …


#2

In-place parameter assistance is intended to set param values and navigate between them using Tab and Shift+Tab. If you do anything else then it will cancel and remove its inserted text. Once you start changing the case as you’re doing it cancels.

There is an option we use for various things like this already, but inline param assistance does not obey it. I’ll log this to have it obey. On the Editor|Behavior page in Options the “Use lower case object…” options is the option I refer to.

Michael