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

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 Sat Aug 22 1998 - 12:15:46 CDT