Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using Host varisbles Using ODBC
I believe you can try it. I think there is an API call to parameterize a
query. However, test it because usually it is just a string substitution and
so it ends up not actually using host variables.
If you have 8.1.7 you can use cursor_sharing=force in the init.ora parameter
file. The Oracle will translate queries that do not have host variables to
ones that do. Not as good as using host variables, but better than not.
Jim
"FaheemRao" <faheemrao_at_yahoo.com> wrote in message
news:43b58913.0108281820.693f278d_at_posting.google.com...
> Hi All,
>
> My Application using ODBC to connect to Oracle Database,
>
> Now as I am hardcoding the values in SQL queries like this
>
> select * from table_name where column_name = 1234;
>
> Now every time I issue above SQL if column_name is different every
> time
> like
>
> select * from table_name where column_name = 444;
>
> Oralce parse this SQL , which takes time, I know One way is to do
> using Host Variables in pro c/c++ , but I cannot use pro c/C++
> because whole application is design to use ODBC , now my question is
> that is there any way that I can use host variables Using ODBC, Or any
> other way so that Oracle do not parse my SQL Queries every time .
>
> thanks
>
> Faheem
Received on Tue Aug 28 2001 - 21:30:58 CDT