The same mistake continues
Oracle Version
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.5.0
Oracle Data Provider for Net 9.2.0.7
Oracle Net 9.2.0.1.0 (I installed the "Oracle Data Provider for Net 9.2.0.7" and was installed this version)
I need change de Oracle Net??? (¿Can I download from where?)
Search found 4 matches
- Wed 17 Sep 2008 20:47
- Forum: dotConnect for Oracle
- Topic: about create ado.net entity data model
- Replies: 25
- Views: 16085
- Mon 15 Sep 2008 14:50
- Forum: dotConnect for Oracle
- Topic: about create ado.net entity data model
- Replies: 25
- Views: 16085
I am importing as Exhibit 3 tables, but to have the error, imported a single table and the error persists.
The tables are really small, a table have eleven fields, other table have four fields and another table has two fields. I tried each of these individual.
Table details:
create table TLC_SUSPREAC_TA_ARCHIVO
(
ID_SECUENCIA NUMBER not null,
NOMBRE_ARCHIVO VARCHAR2(50) not null,
USUARIO VARCHAR2(20) not null,
COMENTARIO VARCHAR2(1024)
)
alter table TLC_SUSPREAC_TA_ARCHIVO
add constraint PK_SUSPREAC_SECUENCIA primary key (ID_SECUENCIA)
create table TLC_SUSPREAC_TA_LINEAS
(
NUMERO VARCHAR2(50) not null,
FK_ID_SECUENCIA NUMBER
)
alter table TLC_SUSPREAC_TA_LINEAS
add constraint FK_SUSPREAC_IDSECUENCIA foreign key (FK_ID_SECUENCIA)
references TLC_SUSPREAC_TA_ARCHIVO (ID_SECUENCIA);
create index IDX_SUSPREAC_IDSECUENCIA on TLC_SUSPREAC_TA_LINEAS (FK_ID_SECUENCIA)
create index IDX_SUSPREAC_NUMERO on TLC_SUSPREAC_TA_LINEAS (NUMERO)
create table TLC_SUSPREAC_TA_LOG
(
FK_ID_TRANSACCION NUMBER(15) not null,
FK_ID_SECUENCIA NUMBER(15),
DESC_TIPO_TRANSACCION VARCHAR2(100),
PRODUCTO NUMBER(15),
NUMERO VARCHAR2(50),
FECHA DATE,
SOLICITUD NUMBER(15),
MOTIVO NUMBER(15),
USUARIO VARCHAR2(50),
COMENTARIO VARCHAR2(1024),
ESTADO VARCHAR2(4000)
)
alter table TLC_SUSPREAC_TA_LOG
add constraint FK_ID_SECUENCIA foreign key (FK_ID_SECUENCIA)
references TLC_SUSPREAC_TA_ARCHIVO (ID_SECUENCIA);
alter table TLC_SUSPREAC_TA_LOG
add constraint FK_ID_TRANSACCION foreign key (FK_ID_TRANSACCION)
references FLEX.TLC_TA_APIS_TRANSACCION_LOG (ID_TRANSACCION);
create index IDX_ID_TRANSACCION on TLC_SUSPREAC_TA_LOG (FK_ID_TRANSACCION)
create index IDX_SUSPREAC_TALOG_NUMERO on TLC_SUSPREAC_TA_LOG (NUMERO)
create index IDX_SUSPREAC_TALOG_PRODUCTO on TLC_SUSPREAC_TA_LOG (PRODUCTO)
The tables are really small, a table have eleven fields, other table have four fields and another table has two fields. I tried each of these individual.
Table details:
create table TLC_SUSPREAC_TA_ARCHIVO
(
ID_SECUENCIA NUMBER not null,
NOMBRE_ARCHIVO VARCHAR2(50) not null,
USUARIO VARCHAR2(20) not null,
COMENTARIO VARCHAR2(1024)
)
alter table TLC_SUSPREAC_TA_ARCHIVO
add constraint PK_SUSPREAC_SECUENCIA primary key (ID_SECUENCIA)
create table TLC_SUSPREAC_TA_LINEAS
(
NUMERO VARCHAR2(50) not null,
FK_ID_SECUENCIA NUMBER
)
alter table TLC_SUSPREAC_TA_LINEAS
add constraint FK_SUSPREAC_IDSECUENCIA foreign key (FK_ID_SECUENCIA)
references TLC_SUSPREAC_TA_ARCHIVO (ID_SECUENCIA);
create index IDX_SUSPREAC_IDSECUENCIA on TLC_SUSPREAC_TA_LINEAS (FK_ID_SECUENCIA)
create index IDX_SUSPREAC_NUMERO on TLC_SUSPREAC_TA_LINEAS (NUMERO)
create table TLC_SUSPREAC_TA_LOG
(
FK_ID_TRANSACCION NUMBER(15) not null,
FK_ID_SECUENCIA NUMBER(15),
DESC_TIPO_TRANSACCION VARCHAR2(100),
PRODUCTO NUMBER(15),
NUMERO VARCHAR2(50),
FECHA DATE,
SOLICITUD NUMBER(15),
MOTIVO NUMBER(15),
USUARIO VARCHAR2(50),
COMENTARIO VARCHAR2(1024),
ESTADO VARCHAR2(4000)
)
alter table TLC_SUSPREAC_TA_LOG
add constraint FK_ID_SECUENCIA foreign key (FK_ID_SECUENCIA)
references TLC_SUSPREAC_TA_ARCHIVO (ID_SECUENCIA);
alter table TLC_SUSPREAC_TA_LOG
add constraint FK_ID_TRANSACCION foreign key (FK_ID_TRANSACCION)
references FLEX.TLC_TA_APIS_TRANSACCION_LOG (ID_TRANSACCION);
create index IDX_ID_TRANSACCION on TLC_SUSPREAC_TA_LOG (FK_ID_TRANSACCION)
create index IDX_SUSPREAC_TALOG_NUMERO on TLC_SUSPREAC_TA_LOG (NUMERO)
create index IDX_SUSPREAC_TALOG_PRODUCTO on TLC_SUSPREAC_TA_LOG (PRODUCTO)
- Thu 11 Sep 2008 16:45
- Forum: dotConnect for Oracle
- Topic: about create ado.net entity data model
- Replies: 25
- Views: 16085
- Thu 11 Sep 2008 14:11
- Forum: dotConnect for Oracle
- Topic: about create ado.net entity data model
- Replies: 25
- Views: 16085
I have a serious problem:
-- Adding an item type ASO.Net Entity Model
-- Select or create a new connection to Oracle
-- Select tables for inclusion in the model
-- Completion
-- Remains hung system, I have to close because no response VS2008
Configuration:
-VS2008 SP1
-ORADIRECT 4.75.41.0
-Oracle 9i
I need to solve this problem in order to generate new projects using your provider.
Thanks,
-- Adding an item type ASO.Net Entity Model
-- Select or create a new connection to Oracle
-- Select tables for inclusion in the model
-- Completion
-- Remains hung system, I have to close because no response VS2008
Configuration:
-VS2008 SP1
-ORADIRECT 4.75.41.0
-Oracle 9i
I need to solve this problem in order to generate new projects using your provider.
Thanks,