JDeveloper: problem with sql-syntax

From: Mathias Kretz <kretz.mathias_at_kvnb.de>
Date: 27 Nov 2001 02:20:07 -0800
Message-ID: <c4f8c879.0111270220.972ab05_at_posting.google.com>

Hi all. I developed a test application using JDeveloper 3.2.3. I can run it against a server 8.1.7 database.

I created a UI containing some objects like textfieldcontrol and LOV for examble. In the dialog, where I have to connect the LOVrowset (underlying the LOV) to the databaseviews, I`m askes to define some conditions, how to select the datas. When I put in a correct 'order by'-statement, I get a information box displaying the following error:

Query execution failed
ORA-00907: right parentheses missing

Any ideas? Both my local and the remote computers are running Windows NT4.0. I am using java v1.3.1.

Thanks for any help.

Mathias Received on Tue Nov 27 2001 - 11:20:07 CET