Toad World® Forums

Formatting of parameters on execute immediate

All,

I’m currently on Toad for Oracle Beta 12.12.0.29.

I have an exception handler that is formatted as follows:
exception
when others
then
execute immediate ‘begin
utl_krg.msg_log.standard_exception_handler(p_caller => :caller
, p_msg_code => :msg_code
, p_local_msg_prefix => :prefix
, p_message => :message
);
end;’
using in l_my_schema || ‘.’ || l_my_routine
, sqlcode
, ‘UTL’
, sqlerrm;
end msg_types_rbi;

The parameters are not aligned properly. This is due to the last three parms not having the ‘IN’ keyword explicitly specified.
also, when mixing IN and OUT parms, they do not align properly.

Any chance of getting this fixed, please?

Thanks in advance,
Abe Kornelis