Toad World® Forums

Formatter problem with EXCEPTION WHEN

formatter will not stack or wrap my OR conditions.

EXCEPTION
WHEN null_policy_number OR null_policy_renewal_num OR policy_map_not_found OR policy_prev_canceled OR too_many_policy_map OR too_many_vendors OR vendor_not_found OR vendor_program_not_found THEN
NULL;
END main_cursor_error_trap;

I’ve tried every Formatter option but I can’t find one that fixes this.

Toad for Oracle Xpert Version 12.0.0.61

Thanks

Mike

This is a very true comment, indeed we are not formatting EXCEPTION ORs indeed.

I’ll add that to the list.

Thanks,

Andre

Done. The AND-OR option tab will now control a list of OR:ed exceptions.

You’ll see it in one of the next Toad betas, as of QP5.dll version 5.267.