SQL on oracle database doesn't return a value

[Bluefields]

Hey there,

I'm using this SQL script in my QTP script, to retrieve a single value:

Code:

process_id_t1=db.execute("select id from ld_process_type where process_type in ('D2')")

The SQL script is OK, but the value doesn't get assigned to the QTP internal variable "process_id_t1". Is anything wrong with the syntax?

Thx and regards,
Roland

[Shridevi.Salagare]

Hi,
Have you checked the connetion string whether its proper?

When I use the query to get output ..I generally create a ADODB record set and ADODB connection object and capture the output in it.

[Bluefields]

Hey,

the connection string is OK, I created a ADODB record set and connection object too. The funny thing is, it's not a problem to write any data to the database, just getting the output doesn't work.

Can you please post the ADODB record set and connection object which you're using?

Thx and regards,
Roland