Re: Ambiguous column name error after installing new server

On Jan 28, 8:02 am, Nicolas Avila <nicolasav..._at_gmail.com> wrote:
> Hello
>
> I was using an Orcale 9i server on one of my applications and it
> worked fine.
>
> Now I installed a new server and got installed an Oracle 11g
>
> I am getting errors in the application which I didn't get before on my
> old server.
>
> The rarest one is a 'column ambiguosly defined' error in some (actualy
> many) stored procedures.
>
> Due to many stored procedures do dinamiclly generate the where filter
> i can not just fix the ones that didn't compile.
>
> In the 'old' server I DID get many times this error, so I guess (?)
> that this error was not happening IF the query was written using ANSI
> joins...
>
> Now the questions:
> - Was this really so at oracle 9? Is this change reported? I mean to
> do NOT support ambiguous column-names in ANSI joins at ORACLE 11.
> - Is this maybe configurable? Can I configure the new server to work
> as my old one did?

Are the column names in your dynamic SQL *actually* ambiguous? If yes, either improve your stored procedures or keep using what previously worked. If no, then open an SR with Oracle. Seems simple enough to me. Of course without knowing more, I am suspecting your application is what has really changed and is now rejecting what Oracle 11g is sending it even though it is the same as what 9i was sending it.

Michael O
http://blog.crisatunity.com Received on Mon Jan 28 2008 - 09:07:52 CST