Re: ORA-00928: missing SELECT keyword

Hi all,
Thanks for all your input.
I am using Oracle 9i(RedHatLinux) version 9.2.0.3 . I have been trying the SAME query (no schema prefix) from sql*plus against same set of data in two different schemas. One schema yields result without any error but the query gives ORA-00928 error. Once again, there is NO single change in the sql statement.

The query is very lengthy one, 14 tables involved, a bit complex and uses ANSI joins. I cannot publish the query because I am not permitted to do.

We had raised the issue with Oracle technical support before posting this in this group.

We are very much sure that there is no problem in query side.

Sorry again for providing limitted information.

Thanks
Anas

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<1111158048.112978.230600_at_o13g2000cwo.googlegroups.com>...
> anaskhans_at_gmail.com wrote:
> > Hi All,
> > I am using the same query against 2 schemas in same server having
> same
> > set of tables and data . Do you think in such a situation the seeing
> > the query has any importance?
>
> You've reported an error which is almost certainly a syntax error in
> the query. There is only one way to find that and that is to look at
> the query. If you don't wish to do that on usenet, then the most
> appropriate course of action would be to log a tar with support.
>
> Niall
Received on Thu Mar 24 2005 - 11:19:41 CST