Routine () can not be resolved. A recursive procedure
<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>