Using Host Variables in ODBC -Oracle Enviornment

[faheemrao]

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

 

[rcurva]

You can make use of stored procedures and REF CURSORS or table of records to return the values from your stored procs.