Re: Invalid attribute/identifier error

On Tue, 15 Mar 2005 07:02:07 -0800, ghosh.sujay wrote:

> HI ,
>
> My application runs fine when I am using SQL Server 2000 as its db,
> but it gives a message "Invalid attribute/identifier" error when the
> db is Oracle .
>
> Any help in this matter would be appreciated .
>
> Thanks ,
>
> Sujay

Based on the incredible lack of information you provide, I suspect that Frank's answer comes close. He is, in fact, telling you that there is a syntax error somewhere but you are not giving enough to clearly identify the error.

However, if you want assistance more than cynical comments, you need to provide a few more things, like:

the oracle version, the oracle database platform, what the client application is written in, what the client platform is, how is the client connecting to the database, the exact error message, when the error message occurs, and so on.

Now, since this is an attribute or identifier error, I strongly suspect the app is referencing a table or column in mixed case and you are or are not using double quotes around the identifier properly - or- your application includes some of Oracle's reserved words in the column or table name. In either case, the best bet is to purchase Thomas Kyte's "Effective ORacle By Design" and read at least the first 3 chapters.

(I would, and I'm sure Frank would, be happy to resolve this minor inconvenience for a modest fee <g>)

/FGB Received on Tue Mar 15 2005 - 09:58:30 CST