Re: multiple runs with the same ref cursor?

A good approach using dynamic SQL which can use indexes but does not have the drawback of shared pool fragmentation that will happen if bind variables are not used is described at Ask Tom here.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1288401763279

It uses sys_context to prevent literals being embedded in the SQL statement. I have used this technique myself and it works very well.

Hth

-- 
MJB