ambiguous columns error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
jerryk
Posts: 8
Joined: Mon 02 Aug 2010 18:47

ambiguous columns error

Post by jerryk » Fri 22 Feb 2013 13:04

Hi,

When using Entity Framework to query a view (5 tables or so) I am generating an ambiguous column error. The query of the view works fine when I run it standalone, ie. in Toad or other SQL command line interface. What is the best approach to troubleshoot this issue? Specifically I would like to see the generated SQL that is throwing the error and understand how I can alter the SQL.

Thanks,

Jerry

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: ambiguous columns error

Post by Shalex » Fri 22 Feb 2013 17:53

1. Please turn on the dbMonitor tool, find the generated SQL, and execute it via plain ADO.NET or some database management tool. Does the problem persist in this case? If yes, specify the SQL.
2. Tell us the exact text of the exception and its call stack.
3. If possible, send us a small test project to reproduce the issue in our environment.

Post Reply