Matteo Gattoni wrote:
> HI,
> I'm still trying to fetch datas in a recursive function. Waiting for
> your responses to my latest email (that follows), I've tried changing the
> structure of my algorithm.
> Now I use a function that is called in an update statement like:
>
> UPDATE PSF.ACTIVITY_
END;
>
> and call it in this way
> UPDATE PIPPOZ SET VALO = PIPPOS(4) WHERE Prova = 1
>
> In this example everything goes as excepted.
>
> What's wrong with the first function (FIX_TREE_D)? Why does it seem that
> the locking is different between the first and the example
en the first and the example?
However, I need to call recursevly the function; so the problem with Cat_cache_supply
(reported in the previous email here following attached) still remains.
At the same way, I still have problem fecthing dynamic cursors (as reported in the
other mail here attache
HI,
I'm still trying to fetch datas in a recursive function. Waiting for your responses
to my latest email (that follows), I've tried changing the structure of my algorithm.
Now I use a function that is called in an update statement like:
UPDATE PSF.ACTIVITY_RELATIONSHIP set C_TREE_PATH = FIX_T