>1.I want the table to be closed when it leaves from the middle-tier and because the table is a cursor when you close it, it is been lost
>2.If you dont close the cursor you get the error: file is in use, at the presentation tier ...

How about just using the AGAIN clause with the DBF function and give it another alias?

Renoir