• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error - [ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinc

 
Vasudevan Gopalan
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am using oracle 8i as database.I tried to execute the following query in JSP.
select phase_id,0 work_package_id,0 activity_id,0 sub_activity_id,0 template_id,seq_no,phase_name name,1 level_id,null mandatory from phase_master
union
select phase_id,work_package_id,0,0,0,seq_no,work_package_name,2,mandatory from work_package_master
union
select wm.phase_id,am.work_package_id,am.activity_id,0,0,am.seq_no,am.activity_name,3 ,am.mandatory from activity_master am,work_package_master wm where am.work_package_id= wm.work_package_id union select wm.phase_id,wm.work_package_id,am.activity_id,sm.sub_activity_id,0,sm.seq_no,sm.sub_activity_name,4,sm.mandatory from sub_activity_master sm,activity_master am,work_package_master wm where sm.activity_id=am.activity_id and am.work_package_id=wm.work_package_id
order by 1,2,3,4,5,6
I am getting the following error:
[ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set
The same above query is working in Oracle sql editor but not in JSP.I am not sure that error is because of driver i am using.I am using Microsoft ODBC for oracle.Could u suggest any solution to my problem.

Regards
Vasu
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic