When optimizing a statement that has the following clause in it, I get an error that says, "Format '%s' invalid or incompatible with argument".
AND NVL(substr(upper(translate(i1.invoice_num,'a!@#/-_$%^&*.','a')), 1),'NomatchKluDge1') = NVL(
substr(upper(translate(i2.invoice_num,'a!@#/-_$%^&*.','a')), 4),'NomatchKluDge1')
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center