ORA-00936: missing expression
ORA-00936: missing expression
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...
"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...
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
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!
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!
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24