title: Routine () can not be resolved. A recursive procedure
body: <p>Procedure for crawling on a tree. When you call a recursive procedure SQL Error (-674): Routine (depending_get_vetka) can not be resolved.</p>
  
  <blockquote>
    <p>IBM Informix Dynamic Server Version 11.70.FC3</p>
  </blockquote>
  
  <pre><code>CREATE PROCEDURE "informix".depending_get_vetka(p_vetka integer default 0)
      RETURNING 
      int as nomerVetki;
  
  define _nomerVetkiChild int;
  define _itemproperties varchar(255);
  
  let _nomerVetkiChild = 0;
  let _itemproperties = '';
  
  FOREACH select p.itemproperties into _itemproperties from param_menu p where (p.vetka = p_vetka) and NOT ((p.itemproperties is null) or (p.itemproperties = ''))
  
      select vetka into _nomerVetkiChild from menu where codename = _itemproperties;
      return _nomerVetkiChild WITH RESUME;
  
      execute procedure depending_get_vetka(_nomerVetkiChild);
  END FOREACH;
  
  END PROCEDURE;
  </code></pre>