Re: ORA-00911 error!

From: Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com>
Date: Fri, 29 Jun 2001 08:43:17 GMT
Message-ID: <3B3C3F01.55D0BA46@hollomey.com>

remove the semicolon (;) at the end of your select statement and try again :-)

mpowell wrote:

> I am using ADO and trying to connect to an Oracle 8i (I think) database. I
> seem to connect using my connect string, however, when I submit the
> following SQL statement I receive an ORA-00911 error. The same query runs
> fine using the Oracle ODBC 32Bit Test application.
>
> SELECT C.CUSTOMERNO, C.COMPANYNAME FROM A_RCUST C WHERE ENTITY_CODE='DALLAS'
> ORDER BY C.CUSTOMERNO;
>
> Any ideas? Thanks!
Received on Fri Jun 29 2001 - 03:43:17 CDT