AW: CAT_CACHE_SUPPLY in Recursive function

2004-06-28 Thread Anhaus, Thomas
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_

AW: CAT_CACHE_SUPPLY in Recursive function -> Lock wainting

2004-06-28 Thread Zabach, Elke
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

CAT_CACHE_SUPPLY in Recursive function -> Lock wainting

2004-06-23 Thread Matteo Gattoni
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

CAT_CACHE_SUPPLY in Recursive function

2004-06-22 Thread Matteo Gattoni
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