Toad World® Forums

BUG: Editing a Stored Procedure


#1

Changing the template in the “Stored Procedure” properties dialog in the SQL tab is usually enough to completely screw up everything. For example, changing from Body to “Complete” and then back again - simply changing it, no other action than selecting the dropdown - is enough to insert trash into the Body text. Unwisely saving the result ruins everything, no matter what’s entered for the template it will misgenerate afterwards. EXTREMELY annoying.


#2

Hi,

thanks for your feedback. Let me explain the current functionality on simple example:

ADD content defined in your template to SQL tab of stored procedure

  1. Edit SQL code of your stored procedure.
  2. Click on position where you plan to add content defined in your template.
  3. Select your template from combo box.
  4. Click the Insert Template icon next to the combobox with list of templates.

In result, the content of your template was inserted to the defined position.

REPLACE selected text by content defined in your template.

  1. Edit SQL code of your stored procedure.
  2. Use your mouse to select text that should be replaced by your template.
  3. Select your template from combo box.
  4. Click the Insert Template icon next to the combobox with list of templates.

In result, the selected text disappeared and content of the template was inserted to the body as a replacement for your text selection.

The current behavior just removes step 4 in both scenarios. Selection of item in combobox immeditely adds content to the body. This was meant as a timesaver.

I created new change request to force users to click the Insert Template icon after changing selection in the combo box. CR#105162.

Regards,

Vaclav