Using Host Variables in ODBC -Oracle Enviornment

Using Host Variables in ODBC -Oracle Enviornment

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:22:18 CDT