da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Problem with ORDER BY in UPDATE

Forum List » NCOCI8 » General English

hattila
User

Fresh Boarder

Posts: 5

Karma: 0

Problem with ORDER BY in UPDATE

Posted: 2000/11/06 11:24

I have updateable SQL statment on one table(ROWID included) with ORDER BY clause. In this situation I get error message "missing right parenthesis" ORA-907. I couldn't make any changes in this type of query. Why?

Diman

Admin

Posts: 1495

Karma: 19

RE: Problem with ORDER BY in UPDATE

Posted: 2000/11/06 13:10

Hi !

It is because, NCOCI8 builds UPDATE / DELETE / INSERT SQL's as follows. For example:
UPDATE (<original query>

SET ... WHERE ...
Oracle prior 8.1.6 is not support such syntax. To overcome this limitation, you should use TOCIUpdateSQL.

Forum List » NCOCI8 » General English