ORA-00904

ORA-00904

Postby rob » Thu 08 May 2008 19:34

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?
rob
 
Posts: 3
Joined: Thu 01 May 2008 18:48

INDEXOF

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.
rob
 
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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for Oracle