When running something like the following:
IEnumerable txs =
from tx in db.ALL_SINGLY_OCCURRING_FIELDS
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?
ORA-00904
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24