Hi ,

Have any one come across a problem like this ,
I have written a dynamic query in the function which is totally diffrent from what i could see at the oracle level . The attachment will make it clear .

Regards,
Niraj

Your problem is not clear ????

Although I'm not familiar with these query.extend.* functions, I wonder about your second function call. Here you are using the table tcztc909 which has not later where conditions -- full join or something like that?

Günther