Using Host Variables in ODBC -Oracle Enviornment
From: FaheemRao <faheemrao_at_yahoo.com>
Date: 28 Aug 2001 19:23:00 -0700
Message-ID: <43b58913.0108281822.7534041f_at_posting.google.com>
Hi All,
Date: 28 Aug 2001 19:23:00 -0700
Message-ID: <43b58913.0108281822.7534041f_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 Wed Aug 29 2001 - 04:23:00 CEST