Postby rob » Thu 08 May 2008 19:34

When running something like the following:
IEnumerable txs =
where (tx.C300_STATE_COUNTRY.Contains("MD")
|| tx.C300_STATE_COUNTRY.Contains("VA")
|| tx.C300_STATE_COUNTRY.Contains("DC"))
select tx;

I get the following:
E:\Documents and Settings\Rob\My Documents\Visual Studio 2008\Projects\yet-another-test\yat\bin\Debug>yat
System.Data.CommandExecutionException: An error occurred while executing the command definition, see the inner exception for details. ---> C
oreLab.Oracle.OracleException: ORA-00904: "INDEXOF": invalid identifier
at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at CoreLab.Oracle.Entity.d.a.a(CommandBehavior A_0)
at CoreLab.Oracle.Entity.d.a.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.Internal.ObjectQueryImplementation`1.MaterializeResults(ObjectQueryExecutionInfo execInfo, MergeOption mergeOption
at System.Data.Objects.Internal.ObjectQueryImplementation`1.GetResults(MergeOption mergeOption)
at System.Data.Objects.ELinq.ELinqQueryImplementation`1.GetResults()
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at yat.Program.Main(String[] args) in e:\Documents and Settings\Rob\My Documents\Visual Studio 2008\Projects\yet-another-test\yat\Program
.cs:line 26

The Contains method is causing the problem. Should I not be able to use this?
Posts: 3
Joined: Thu 01 May 2008 18:48


Postby rob » Fri 09 May 2008 13:13

I think the driver is attempting to use an INDEXOF operator to search for the string which I don't think is present in oracle. Please advise.
Posts: 3
Joined: Thu 01 May 2008 18:48

Postby Alexey.mdr » Mon 12 May 2008 13:43

Thank you for the bug report.
The situation is quite complicated.
We are working on the problem, please be aware that this will
take some time and plan your development strategy accordingly.
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Return to dotConnect for Oracle