[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] [Microsoft][ODBC driver for Oracle]Cannot useKeyset-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