Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting up Oracle for NT - 8.0.4

Re: Setting up Oracle for NT - 8.0.4

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Wed, 11 Nov 1998 00:05:11 GMT
Message-ID: <3648d47f.8568909@newshost.interact.net.au>


On Mon, 09 Nov 1998 22:12:29 GMT, oldgent_at_hotmail.com wrote:

>We recently purchased Oracle 8 for NT. We have an application which runs in
>SQL Server, but does not run in Oracle. It appears the main problem is that
>double quotations were used within the SQL statements generated by the
>application program.
>
>Ex. Select * from swpipes where pipeno = "A1234"
>
>Is there a setting with Oracle which will allow it to accept such a SQL
>statement without giving an error?
>
>Thanks in advance for your help.

The statements generated are using non-standard quotes. Why not change them to single quotes, and save yourself many future problems.

Ciao
Fuzzy
:-) Received on Tue Nov 10 1998 - 18:05:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US