PRO*C Advice needed for dynamic SQL to avoid reOPENing cursor

Hi

If I have a cursor :

CURSOR mycursur IS
SELECT x,y,z from MYTABLE
WHERE x = :bind1 AND y = :bind2;

can anyone advice me of the PRO*C required to make this fully dynamic, so from a loop I can set the bind variable each iteration, and array fetch the results, without having to reopen the cursor each time? I'm having performance problems with the time its taking to do an OPEN CURSOR. Array fetching is not a problem.

Advice could correspond to writing dynmic SQL using "Method 4" in the online Oracle documentation. I'm having terrible problems.

Thanks in advance
Scott Received on Tue Nov 21 2000 - 16:25:59 CST