"nsmith22" <nsmith22_at_gmail.com> wrote in message
news:1160785569.715764.238750_at_m73g2000cwd.googlegroups.com...
> 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
>
What is the business need? Your description sounds very open to sql
injection. Why do you need total dynamic sql?
Jim
Received on Fri Oct 13 2006 - 20:12:10 CDT
