Dynamic SQL Method 4 : Avoid Re-parsing?

My overall goal is to get results from arbitrary SQL queries (only queries) using bind variables with a single function that communicates with Oracle. I have been able to accomplish this with ANSI Dynamic SQL Method 4 (using Pro*C), but it forces me to do a prepare, declare cursor, open cursor, fetch, and close cursor each and every time. The huge cost is in the prepare, which forces some kind of parsing (I think hard parse) every time.

Is there a way to achieve the same thing in Pro*C, stored procedures, OCI, or anything else that will improve performance?

If you would like a code sample I can provide that.

Thanks,
Nicholas Smith Received on Fri Oct 13 2006 - 19:26:09 CDT