tag:blogger.com,1999:blog-15861274.post112575471790364853..comments2023-09-18T11:14:24.509+01:00Comments on Oracle WTF: If at first you don't succeedWilliam Robertsonhttp://www.blogger.com/profile/06976436975493102341noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-15861274.post-1126280334466183282005-09-09T16:38:00.000+01:002005-09-09T16:38:00.000+01:00Maybedi_core.di_tools.area_code_translate(v_switch...Maybe<BR/><BR/>di_core.di_tools.area_code_translate(v_switch_id,d.dncode)<BR/><BR/>returns a different result on alternate calls?Adrianhttps://www.blogger.com/profile/00943497054353493755noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-1125939077716970172005-09-05T17:51:00.000+01:002005-09-05T17:51:00.000+01:00Is there a route for submitting examples for your ...Is there a route for submitting examples for your consideration?<BR/><BR/>I have a rather fine 985-line SQL Loader control file I'd like to tell you about...Tony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-1125937572651207812005-09-05T17:26:00.000+01:002005-09-05T17:26:00.000+01:00That's crazy. It should obviously be:-COALESCE ( ...That's crazy. It should obviously be:-<BR/><BR/>COALESCE (<BR/> di_core.di_tools.area_code_translate(v_switch_id,d.dncode),<BR/> di_core.di_tools.area_code_translate(v_switch_id,d.dncode),<BR/> di_core.di_tools.area_code_translate(v_switch_id,d.dncode)<BR/>)<BR/><BR/>...because there's no guarantee the second one will be non-null ;o)OraWTFGuyhttps://www.blogger.com/profile/07131527523004188665noreply@blogger.com