[Zope-DB] ZOracleDB strange error

[Smith, Neil (Worcester)]

It's not strange at all, take out the semicolon at the end.  As the error
says, it's an invalid character.

--
Neil

-----Original Message-----
From: Johnny Wezel [mailto:j@netfeed.ch]
Sent: 11 February 2003 09:07
To: zope-db@zope.org
Subject: [Zope-DB] ZOracleDB strange error
Importance: High


I finally got Oracle 9i up and compiled ZOracleDA. When I tried to test
it using this simple query:

SELECT * FROM ALL_TABLES WHERE OWNER = 'PATENT';

I got this error in the sql test page:

Error, oci.error: (911, 'ORA-00911: invalid character\n')

and this strange error message in the Zope log:

Exception Type  oci.error
...







**********************************************************************
 
The information contained in this e-mail is confidential and 
intended only for the use of the addressee. If the reader of 
this message is not the addressee, you are hereby notified 
that you have received this e-mail in error and you must not 
copy, disseminate, distribute, use or take any action as a 
result of the information contained in it.
    
If you have received this e-mail in error, please notify 
postmaster@npower.com (UK 01384 275454) and delete it 
immediately from your system.
    
Neither Npower nor any of the other companies in the 
Innogy group from whom this e-mail originates accept any 
responsibility for losses or damage as a result of any viruses 
and it is your responsibility to check attachments (if any) for 
viruses.
Npower Limited
Registered office: Windmill Hill Business Park, Whitehill 
Way, Swindon SN5 6PB. Registered in England and Wales: 
number 3653277
This e-mail may be sent on behalf of a member of the Innogy 
group of companies.
**********************************************************************