# Dropping procedure from decribe window does not capture parameter names **URL:** \ **Category:** SQL Navigator\ **Created:** [March 19, 2009, 5:48am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703 "2009-03-19T05:48:41Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 19, 2009, 5:48am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/1 "2009-03-19T05:48:41Z")
See the screenshot - this code is captured when dropping get\_line from describe. For long parameter lists it would be better to capture the parameter names too. This would be a good help to change one parameter after another to the desired input. Maybe a preference would be a good way to control the behavior. ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg) ---
**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\ **Post date:** [March 19, 2009, 7:18am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/2 "2009-03-19T07:18:27Z")
I’d additionally suggest to use the “=\>” syntax, ready to be filled in: SYS.DBMS\_OUTPUT.GET\_LINE(LINE =\> , STATUS =\> ) ---
**Author:** ![roman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/roman/32/65_2.png) [@roman](https://forums.toadworld.com/u/roman)\ **Post date:** [March 19, 2009, 6:02pm UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/3 "2009-03-19T18:02:42Z")
Hi Torsten, Have you tried Code Completion? If it’s on, when you enter an opening bracket after a procedure name, it will show you a list of possible parameter lists (more than one if the procedure is overloaded). You just pick one and press Enter, and it will be inserted in text (in a similar format to what you suggested). Hope this helps, Roman ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 20, 2009, 3:24am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/4 "2009-03-20T03:24:34Z")
I don’t prefer the “=\>” syntax, as this can gives problems when changing later the count of parameters. I prefer positional notation. But maybe a preference with a list? Roman - for code completion we have an open bug, as after enter bracket no parameter list is shown here. This happens in the beta too. ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [March 22, 2009, 6:26pm UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/5 "2009-03-22T18:26:03Z")
Hi Torsten, I cannot reproduce the issue with parameter list. Could you please give us an example? Gwen ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 23, 2009, 3:23am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/6 "2009-03-23T03:23:37Z")
Have actually a service reqest with support open for this, as the support can not reproduce this too. Fact is that on my side after entering the bracket no parameter list is shown in 6.1 and 6.2 beta. See screen shot for example procedure and add bracket after select enable procedure. Maybe this is related to german installation, as we had errors, where these errors was only reproducable in non english environment? ![lookup_par1.jpeg](https://global.discourse-cdn.com/quest/original/2X/8/87bfbd2c4cd17adb42c95f0439840d8a2ab38120.jpeg) ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [March 23, 2009, 5:32pm UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/7 "2009-03-23T17:32:04Z")
I’m not sure actually. It works fine for me. Maybe you should try uninstall, clear out the environment (registry, etc.) and reinstall again. Gwen ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 24, 2009, 3:25am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/8 "2009-03-24T03:25:03Z")
This is reproducable here on all clients and 3 different versions (6.1, 6.1.1 and 6.2 beta)! ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [March 24, 2009, 11:21pm UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/9 "2009-03-24T23:21:00Z")
Hi Torsten, After you typed in the bracket, did the x button at the top right corner of the code editor greyed out? Have you tried Ctrl+Space to force code completion? Gwen ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 25, 2009, 5:10am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/10 "2009-03-25T05:10:34Z")
The closing x does not disappear before as it does in other dot lookup operations. Ctrl-Space does open the parameter dialog. ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 25, 2009, 5:12am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/11 "2009-03-25T05:12:48Z")
By the way, the “=\>” syntax in parameters is not optimal when you have to refactor later your code with defaults and so on. Therefore I prefer the positional notation of parameter. ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [March 31, 2009, 4:32am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/12 "2009-03-31T04:32:33Z")
Parameter list comes not up in beta build 1317 too. ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [April 7, 2009, 6:15pm UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/13 "2009-04-07T18:15:06Z")
Hi Torsten, I got your support case about this issue with dot-lookup. I still cannot reproduce this issue but I had a wild guess that it may related to the role/privileges that get assigned to your user. Could you provide me with the extracted ddl of the user? (pay attention to select\_catalog\_role) Regards, Gwen ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [April 8, 2009, 2:27am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/14 "2009-04-08T02:27:00Z")
Have reproduced this with 2 seperate computers of 2 separate users in our company. Have reproduced this with 6.1, 6.1.1 and last 6.2 beta releases. Have reproduced this with all used connections, eg. user scott, an almost sys user, a restricted user. As you see in my support case - after entering the bracket no sql statement is fired anymore automatical. So my first shot would be german environment, as we had another case, which was related to this too and was not reproducable before somebody has testet this with another non english environment (belgium). I send you the extract of the user scott. [SCOTT\_ddl.sql](https://global.discourse-cdn.com/quest/original/2X/1/150345b50c9e581f4f21ca3ae7c63f4fb4eabe2b.sql) (466 Bytes) ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [April 8, 2009, 7:38pm UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/15 "2009-04-08T19:38:13Z")
Hi Torsten, Thanks for the info. I will test it with a German environment and see if there’s any luck. We’re having easter holiday coming up so I may not be able to get to this as early as I want to. I will reply back to your subcase early or mid next week. We will try to nail it for 6.2. Thanks Gwen ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [April 14, 2009, 12:48am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/16 "2009-04-14T00:48:47Z")
Hi Torsten, I tested this against a German environment but couldn’t reproduce the issue. Does this package belong to the current schema or a different one? Gwen ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [April 14, 2009, 1:55am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/17 "2009-04-14T01:55:12Z")
As you see in the screeshot above this happens in a simple sql editor but happens too in a package or procedure editor regardless if the edited object is local or in another schema. ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [April 14, 2009, 2:10am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/18 "2009-04-14T02:10:31Z")
you fotgot to attach the screenshot. 😃 ---
**Author:** ![tkleiber](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/tkleiber/32/67_2.png) [@tkleiber](https://forums.toadworld.com/u/tkleiber)\ **Post date:** [April 14, 2009, 2:12am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/19 "2009-04-14T02:12:12Z")
The screeshot is **above -** in the first entry of this thread. ---
**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\ **Post date:** [April 27, 2009, 3:31am UTC](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703/20 "2009-04-27T03:31:15Z")
Hi guys, We did a webex session with Torsten today and found out that the issue is with the keyboard he is using. Torsten is using German keyboard and in order to type an open bracket (, he needs to press shift+8. SQL Nav could not detect this, hence we have issues with the dot lookup. Roman is fixing this issue and it will be included in the next beta release. If anyone has the same problem, please check it with the next beta when it’s available. Thanks in advance, Gwen [Next page](https://forums.toadworld.com/t/dropping-procedure-from-decribe-window-does-not-capture-parameter-names/3703.md?page=2)