SQL="select ts_hsd_mbr from ts_hsd, ts_CVH where ts_hsd_STATUS='AR' and ts_HSD_EXP > SYSDATE and ts_CVH_CC IS NOT NULL AND ts_CVH_RI IS NULL AND ts_HSD_MBR= ts_CVH_MBR AND ROWNUM < 2"
When I trying to run this SQL (Using ORACEL DB) in my script, I am getting runtime error.
"Cannot use key-setdriven cursor on join, with distinct clause,union intersect or minus or on read only results set."
How I can fix this error?
[This message has been edited by tester_qa (edited 01-09-2003).]