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