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

Thanks. I figured out the "AS" problem by looking at the tracing. Anything after "AS" was cut off. I guess "AS" is like "DISTINCTROW" in Access, which is not often useful. I think it works in Rdb though. It would be nice if the Oracle error message was more accurate in this case. BTW, is there an equivalent to the "FIRST" or "LAST" grouping availabe in MS Access? It can be quite useful, but it won't work in Rdb.

Still can't see how the Pass-Through works without the semi-colon: can't see anything in the tracing that helps. I'm getting used to Oracle slowly but surely. Thanks everyone for your help.

In article <shield-2408982155100001_at_news.mindspring.com>,   shield_at_nando.net wrote:
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 25 1998 - 17:33:26 CDT