Re: SQL Command Not Properly Ended (ORA-00933)

If you are using pass-thru mode or sqlplus, you MUST remove the "AS". That is a Microsoft/SQL Server extension to SQL. Also, use single quotes for ALL strings and characters in Oracle. Using double quotes makes oracle think you are naming a column.

HAP In article <6rmuc1$t61$1_at_nnrp1.dejanews.com>, steve_dennis_at_my-dejanews.com wrote:

> Thanks for your responses. I will try the single quoted literal. To clarify,
> the MS Access Pass-Through window would not allow the WHERE clause with the
> double quoted literal. It would not allow the use of the semi-colon under any
> circumstance, although SqlPlus required it always. I tried using a double-
> hypen or dash, but pass-through would not use it as a sql terminator. I'll
> check the applet and see if it adds a semi-colon after I execute the pass-
> through query. I also use the Oracle ODBC driver for Rdb and it will allow
> double quotes, as I recall. It also allows aliasing tables without using
> "AS". I guess I just have to adjust to the language of the country I'm
> visiting!
>
> Thanks again!
>
> In article <35DE84E9.5AC7CBD9_at_sybrandb.demon.nl>,
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
> > In Access Pass through you are still using the Jet engine, and
ODBC.ODBC will
> > interface with sqlnet. Sqlplus interfaces with sqlnet directly. Just as
> > experiment try tracing ODBC calls (enable them using the ODBC applet in
> control
> > panel) and you will see how your statement gets translated by the ODBC
driver.
> > Usually a pass through window forces you to use correct Oracle syntax. It is
> > quite possible behavior at the Microsoft side has changed between versions
> > (Acces 95 uses ODBC 2.5, Access 97 ODBC 3.0). In 2.5 Oracle syntax has to be
> > correct including the semi-colon.
> >
> > Thanks,
> >
> > Sybrand Bakker
> >
> > Kevin P. Fleming wrote:
> >
> > > Well, your first problem is that Oracle uses single-quotes for string
> > > literals, not double quotes...
> > >
> > > As to why it works in the Access Pass-Through window with the double
quotes
> > > but no semicolon, I have no idea.
> > >
> > > steve_dennis_at_my-dejanews.com wrote in message
> > > <6rkkda$9tu$1_at_nnrp1.dejanews.com>...
> > > >I get the error message in the subject line (ORA-00933) when I type the
> > > >following query in SQL*PLUS or MS Access SQL Pass-Through window:
> > > >
> > > >SELECT * FROM DW_PROD.MEMBER_HISTORY AS A
> > > >WHERE A.SUBSCRIBER_ID = "0094100006";
> > > >
> > > >But not if I have no WHERE clause. The query works without a WHERE
CLAUSE
> > > in
> > > >the Access Pass-Through window if I omit the semi-colon; I must use the
> > > >semi-colon in SQL*PLUS. Why must I terminate the SQL statement
differently
> > > >depending on the statement?
> > > >
> > > >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > > >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 24 1998 - 20:55:10 CDT