Cute Code, Zero Logic!

[dr_gori]

This is not an case where the programmer made an error due to ignorance of some Oracle feature. Here, it is clear that the programmer has been lost in a simple IF Else! Logic passed away.

Check:

Select all

if :BL_CLIENTE.NM_CLIENTE IS NULL then 
    PR_INFORMACAO('Não é permitido abrir essa tela enquanto registro não for pesquisado.');  
			 	   
else 
    if ( :bl_cliente.nm_cliente is null ) then 
       ln_mens := fu_alerta('Favor pesquisar um registro.',1); 
       raise form_trigger_failure; 
    end if; 
. 
. 
. 
end if;

He does an IF <condition>. In the Else, it does the same <condition> done above! (That is, of course it will never enter.

[lodvini]

But look ... he at least changed the message ... hehehehehe

[NaPraia]

I think he forgot a not in the IF inside the Else,
but of course, it is rebundancia he put a not inside the else, but at least it would work