Toad World® Forums

Formatter discards some parameters from parameter list

All,

this is a tricky one, that's been biting me quite a few times:

  1. I bring up a template parameter list in the editor by typing in the opening parenthesis and waiting for the list to appear.

  2. I modify the parameters in the template parmlist

  3. I hit Shift-Ctrl-F to reformat the results

  4. some parameters are removed in the formatting process

  5. I hit Ctrl-Z (twice!) to undo formatting, all parms re-appear

  6. I hit Shift_Ctrl-F again: parmlist is reformatted correctly!

  7. If I retry, the template paramlist is no longer generated :frowning:

Plese see the following screenshots to illustrate the sequence of events:

Initial parmlist template brought into editor (see second invocation):

Parmlist as modified by me (again: second invocation):

And the parmlist as maimed by the formatter (again: second invocation):

There was a weird quirk though, while I was producing the screenshots: the problem did not recreate!
When I re-issued the entire sequence, the issue recurred.

This appeaars to be consistent: if I leave the Toad-session to go do something else in between ,then the problem does not occur.

But when I just keep working in Toad, without side-stepping to other applications on my PC, then the problem manifests itself.

I hope this helps.

Finally: here;s the header for the packaged procedure definition:

procedure log_info_msg(p_schema in varchar2

, p_package in varchar2 := '-'

, p_routine in varchar2

, p_action in varchar2 := '-'

, p_msg_id in varchar2 := '-'

, p_message in varchar2 := '-'

, p_company in varchar2 := '-'

, p_wcs_shop in varchar2 := '-'

, p_row_count in number := null

, p_putline in varchar2 := 'PutLine'

, p_debug in varchar2 := 'Nodebug' -- value 'Debug' will activate debugging mode

);

-- pragma autonomous_transaction;

procedure log_info_msg(p_caller in varchar2 -- format as schema.package.routine or schema.routine

, p_action in varchar2 := '-'

, p_msg_id in varchar2 := '-'

, p_message in varchar2 := '-'

, p_company in varchar2 := '-'

, p_wcs_shop in varchar2 := '-'

, p_row_count in number := null

, p_putline in varchar2 := 'PutLine'

, p_debug in varchar2 := 'Nodebug' -- value 'Debug' will activate debugging mode

);

-- pragma autonomous_transaction;

Kind regards,
Abe Kornelis.

Thanks, I’ll take a look when we resume the beta cycle again.

Since inline parameter assistance is an overlay feature it’s designed to be cancelled easily under almost any circumstance like hitting ESC, moving to a new line,
changing active Editor tab, or performing any other action like formatting. Cancellation strips lingering visual effects and text that was automatically inserted. It will require some work to allow it to withstand a format. Perhaps inserting it so it doesn’t
span beyond the right edge of the control (place them on multiple lines) will make it less likely you’ll need to format it before entering values.

There also seems to be a placement issue that need addressed as see n in your
second screenshot where the box doesn’t align to the parameter text.

Thanks,

Michael

From: kornelis.abe [mailto:bounce-kornelisabe@toadworld.com]

Sent: Friday, May 08, 2015 4:16 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Formatter discards some parameters from parameter list

Formatter discards some parameters from parameter list

Thread created by kornelis.abe

All,

this is a tricky one, that’s been biting me quite a few times:

  1. I bring up a template parameter list in the editor by typing in the opening parenthesis and waiting for the list to appear.

  2. I modify the parameters in the template parmlist

  3. I hit Shift-Ctrl-F to reformat the results

  4. some parameters are removed in the formatting process

  5. I hit Ctrl-Z (twice!) to undo formatting, all parms re-appear

  6. I hit Shift_Ctrl-F again: parmlist is reformatted correctly!

  7. If I retry, the template paramlist is no longer generated :frowning:

Plese see the following screenshots to illustrate the sequence of events:

Initial parmlist template brought into editor (see second invocation):

Parmlist as modified by me (again: second invocation):

And the parmlist as maimed by the formatter (again: second invocation):

There was a weird quirk though, while I was producing the screenshots: the problem did not recreate!

When I re-issued the entire sequence, the issue recurred.

This appeaars to be consistent: if I leave the Toad-session to go do something else in between ,then the problem does not occur.

But when I just keep working in Toad, without side-stepping to other applications on my PC, then the problem manifests itself.

I hope this helps.

Finally: here;s the header for the packaged procedure definition:

procedure log_info_msg(p_schema
in varchar2

, p_package
in varchar2
:= ‘-’

, p_routine
in varchar2

, p_action
in varchar2
:= ‘-’

, p_msg_id
in varchar2
:= ‘-’

, p_message
in varchar2
:= ‘-’

, p_company
in varchar2
:= ‘-’

, p_wcs_shop
in varchar2
:= ‘-’

, p_row_count
in number
:= null

, p_putline
in varchar2
:= ‘PutLine’

, p_debug
in varchar2
:= ‘Nodebug’ – value ‘Debug’ will activate debugging mode

);

– pragma autonomous_transaction;

procedure log_info_msg(p_caller
in varchar2 – format as schema.package.routine or schema.routine

, p_action
in varchar2
:= ‘-’

, p_msg_id
in varchar2
:= ‘-’

, p_message
in varchar2
:= ‘-’

, p_company
in varchar2
:= ‘-’

, p_wcs_shop
in varchar2
:= ‘-’

, p_row_count
in number
:= null

, p_putline
in varchar2
:= ‘PutLine’

, p_debug
in varchar2
:= ‘Nodebug’ – value ‘Debug’ will activate debugging mode

);

– pragma autonomous_transaction;

Kind regards,

Abe Kornelis.

==========

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Michael,

Sounds good.

Related to this issue is a feature I really do miss in 12.7 that was present in 12.6.

In 12.6 if you’d invoke iinline parameter asistance, you could move the cursor to a different line and then back into the inserted parameters field.
The cursor would then go to the first unchanged parameter. This made it extremely easy to navigate around, pick up param values from nearby code lines and insert these values into the parmlist.
It works like a charm. I really regret that 12.7 no longer supports this behavior.

Kind regards,
Abe.

This was an oversight. I’ll add this to the logged issue as well.

Michael

From: kornelis.abe [mailto:bounce-kornelisabe@toadworld.com]

Sent: Tuesday, May 12, 2015 9:02 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Formatter discards some parameters from parameter list

RE: Formatter discards some parameters from parameter list

Reply by kornelis.abe

Michael,

Sounds good.

Related to this issue is a feature I really do miss in 12.7 that was present in 12.6.

In 12.6 if you’d invoke iinline parameter asistance, you could move the cursor to a different line and then back into the inserted parameters field.

The cursor would then go to the first unchanged parameter. This made it extremely easy to navigate around, pick up param values from nearby code lines and insert these values into the parmlist.

It works like a charm. I really regret that 12.7 no longer supports this behavior.

Kind regards,

Abe.

===

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Ok, thanks.

Abe