ORA-00936: missing expression

alexonit · Post by **alexonit** » Thu 24 Apr 2008 08:51

Hi, I don't undestand why Oracle give me this error message. I had to select some values from a table, with this linQ expression:

"From tb In entities.T_ANA_GRUPPI_UTENTI Select tb"

It's a very simple query...but something goes wrong for Oracle!

Someone can help me...please?!?!

Thank you so much...

Alexey.mdr · Post by **Alexey.mdr** » Thu 24 Apr 2008 10:58

OraDirect .NET supports LINQ to Entities.
Unfortunately, LINQ to Oracle is not implemented yet.
We are working on implementation of this feature.
For the current moment no time frame is available.

alexonit · Post by **alexonit** » Thu 24 Apr 2008 12:26

At first, thank you for the speedy-answer about my topic.

I only had to perform a selection on a table. In other tables the operation goes right, instead for that table Oracle's output error is that.

With OraDirect I can make that kind of selection...no?!

Alexey.mdr · Post by **Alexey.mdr** » Thu 24 Apr 2008 14:31

Could you please post a table definition script?
Also please post the query that is sent to the database (using OracleMonitor).

alexonit · Post by **alexonit** » Thu 24 Apr 2008 15:04

The table script is:

ALTER TABLE ONHOSPITAL.T_ANA_GRUPPI_UTENTI
DROP PRIMARY KEY CASCADE;
DROP TABLE ONHOSPITAL.T_ANA_GRUPPI_UTENTI CASCADE CONSTRAINTS;

CREATE TABLE ONHOSPITAL.T_ANA_GRUPPI_UTENTI
(
GRU_ID NUMBER(10) NOT NULL,
GRU_CODICE VARCHAR2(16 BYTE),
GRU_DESCRIZIONE VARCHAR2(256 BYTE),
GRU_OBSOLETO VARCHAR2(1 BYTE),
GRU_AZI_CODICE VARCHAR2(10 BYTE) DEFAULT (('080112'))
)
TABLESPACE ONHOSPITAL
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 40K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

CREATE UNIQUE INDEX ONHOSPITAL.T_ANA_GRUPPI_UTENTI_PK ON ONHOSPITAL.T_ANA_GRUPPI_UTENTI
(GRU_ID)
LOGGING
TABLESPACE ONHOSPITAL
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 40K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOPARALLEL;

ALTER TABLE ONHOSPITAL.T_ANA_GRUPPI_UTENTI ADD (
CONSTRAINT T_ANA_GRUPPI_UTENTI_PK
PRIMARY KEY
(GRU_ID)
USING INDEX
TABLESPACE ONHOSPITAL
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 40K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
));

ALTER TABLE ONHOSPITAL.T_ANA_GRUPPI_UTENTI ADD (
CONSTRAINT REFT_ANA_AZIENDE311
FOREIGN KEY (GRU_AZI_CODICE)
REFERENCES ONHOSPITAL.T_ANA_AZIENDE (AZI_CODICE));

The query is made by the LinQ expression:

From tb In Elenco _
Where tb.GRU_DESCRIZIONE = descrizione Select tb

Maybe, the physical field GRU_AZI_CODICE can be the problem due to the fact that in the edmx there isn't...but for other tables this doesn't rapresent a problem!

Alexey.mdr · Post by **Alexey.mdr** » Sat 26 Apr 2008 08:51

Hi!

Try downloading a new build of OraDirect .NET.
There were many improvements and bug fixes relative to Entity Framework.
The issue is not reproducible on the version 4.60.33.

Hope this helps.

alexonit · Post by **alexonit** » Mon 28 Apr 2008 09:25

Ok...I try downloading the new build!

Thank's!

Alexey.mdr · Post by **Alexey.mdr** » Mon 05 May 2008 15:16

Did the newer build solve the problem?