Formula in Parameter of Report ...

[Diego_Mello]

I found this code in a series of User Parameters in a Report ...

Select all

function P_item_iniValidTrigger return boolean is 
 /*cursor c1 is 
  select sbe_ies_codigo 
  from dom_saldo_beneficiamento 
  where sbe_ies_codigo = nvl(:p_item_ini,sbe_ies_codigo) 
    and fil_filial = :p_filial 
    and emp_empresa = :p_empresa; 
 item c1%rowtype;*/ 
begin 
/*	return(true); 
 open c1; 
 loop 
   fetch c1 into item; 
   exit when c1%notfound; 
   return(TRUE); 
 end loop; 
 close c1; 
 return(FALSE);*/ 
  return (TRUE); 
end;

I think I do not need to explain anything ... xDD

[dr_gori]

Someone gave up the cursor and forgot to clean ...: - /

[Trevisolli]

I agree with Dr_Gori.

on Clear , I particularly, when I make a change of great risk (I say great risk because it can compromise a good part, but all, The system), I usually leave commented for a while, for after a time in production, eliminate the object comments.

It is certain that it would not be the case informed in this topic, but for safety, I usually proceed in this way and, after a time approved, in the next change in the object, I carry out the necessary cleaning.

There is a tip.

[Diego_Mello]

I also agree with this, Trevisolli ...

I also do this sometimes ...
but there is one but ...

1st: Report was not changed since 2007 ...
2nd: I found this in all the user parameters of him ...
3rd: What he gave up on commenting, he did in Before Report ...

But at least it worked ... The guy just forgot to delete: D

[dr_gori]

2º: I found this in all the user parameters of it ...

is the famous CC methodology: Copy and Necklace: Shock :