I am not able to execute below querry
"select b.invest_id from sec_price a, security b where a.sec_id = b.sec_id AND invest_id =" & "'" & investid & "'" & " AND " & "price_dt ="& "'" & prc_dte & "'"
here i am passing two parameters investid and prc_dte, whenevr i am trying to execute a querry with any date column, querry is not getting executed at run time
when i am checking in debugging mode, parameter values are correct in the querry.Is there any problem with the DATE format which i am not able to understand.
even a simple querry is not working where i am passing the date
"select b.invest_id from sec_price a, security b where a.sec_id = b.sec_id AND price_dt =" & "'" &prc_dte& "'"
Hey...I got the solution...
I changed the format like this
select b.invest_id from sec_price a, security b where a.sec_id = b.sec_id
AND price_dt = TO_DATE('7/5/2011','MM/DD/YYYY')
may be it wud be helpful to someone
Can you please give the steps, how to connect to the oracle DB from our QTP. i.e connection strings, etc...
U need to first create a Connection Object, then a connection string. Open the Connection with DB and execute the required SQL.
Winds of Change
go here: Connection Strings