RE: [sqr-users] [Microsoft][ODBC driver for Oracle]Cannotuse Keyset-driven cursor on join, with distinct clause, union, intersector minus or on read only result set

["Peter Burton" <peter.burton@oracle.com>]

Harvinder,

Yes ... Use the ODBC drivers supplied with the SQR product rather than the 
Micosoft Oracle ODBC driver.

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of 
Harvinder Singh Narang
Sent: Friday, August 31, 2007 3:01 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] [Microsoft][ODBC driver for Oracle]Cannot use 
Keyset-driven cursor on join, with distinct clause, union, intersect or minus 
or on read only result set

Hi 

 

I am running a following query 

 

SELECT DISTINCT AL1.SUB_ACCT_NO_WOC,AL1.LS_CHG_DTE_WOC FROM 

WOC_BASE_COMP AL1, WOS_SERV_CODE AL2

WHERE AL1.SYS_WOC=AL2.SYS_WOS  AND 

AL2.SERV_NET_CHG_WOS=1 AND 

AL2.SERV_CDE_WOS='RT' AND 

AL1.LS_CHG_DTE_WOC between sysdate-8 and sysdate-2;

 

 

Through SQR which is Giving the following error 

[Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on
join, with distinct clause, union, intersect or minus or on read only
result set

My SQR Version is 8.3

My Oracle version is 9.2

I am using ODBC Driver version 5.75.1117.00 for connecting to Oracle.

 

Can any one provide me a solution for this?

 

 

Regards,

Harvinder Singh Narang

Xavient Information Systems

C-124, Hosiery Complex

Phase - II, Noida

Tel. +91-120 436 2500 Extn. XXX

Fax +91-120 2461970

Mobile 9899328393

Visit us: www.xavient.com

E-mail: hsnarang@xavient.com

 

 

 

========================================================================
==================================
This communication & accompanying documents ("this e-mail") contains
confidential and/or privileged information for exclusive use of the
individual to whom it is addressed. If you are not the intended
recipient, please immediately notify the company & delete this e-mail.
Any unauthorized use or disclosure of this e-mail is strictly
prohibited. Representations in this e-mail are subject to contract. As
an e-mail user please be cautious of the technical & other
vulnerabilities of the internet which may result in malicious and/or
unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank
you. 

========================================================================
==================================

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users