Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting up Oracle for NT - 8.0.4
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