Forums Register Login

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

+Pie Number of slices to send: Send
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
He loves you so much! And I'm baking the cake! I'm going to put this tiny ad in the cake:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2227 times.
Similar Threads
Count query in oracle cursors
SQL Error :Too few parameters.
Cannot understand this error
Newbie encounters table locking
SQL Server Exception
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 02:34:40.