All,
this is a tricky one, that's been biting me quite a few times:
-
I bring up a template parameter list in the editor by typing in the opening parenthesis and waiting for the list to appear.
-
I modify the parameters in the template parmlist
-
I hit Shift-Ctrl-F to reformat the results
-
some parameters are removed in the formatting process
-
I hit Ctrl-Z (twice!) to undo formatting, all parms re-appear
-
I hit Shift_Ctrl-F again: parmlist is reformatted correctly!
-
If I retry, the template paramlist is no longer generated
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;
