Data Set Wizard Bug

Data Set Wizard Bug

Postby degas » Fri 19 Jun 2009 13:18

I have 2 tables with a foreing key.

CREATE TABLE RED.PUNTO
(
ID_PUNTO NUMBER(4) CONSTRAINT NN_PUNTO_ID_PUNTO NOT NULL,
NEMONICO VARCHAR2(12 BYTE),
NOMBRE VARCHAR2(50 BYTE),
ID_TIPO_PUNTO NUMBER(4),
ID_GASODUCTO NUMBER(4),
CODIGO VARCHAR2(12 BYTE),
VIGENCIA_DESDE DATE,
VIGENCIA_HASTA DATE,
NOMBRE_PARA_TGN VARCHAR2(15 BYTE),
ID_CAMARA_VIRTUAL NUMBER(4),
CAMARA_NOMINADA CHAR(1 BYTE) DEFAULT 'N',
ID_PROVINCIA NUMBER(2),
TELEMEDIDA CHAR(1 BYTE) DEFAULT 'N',
ID_ZONA NUMBER(4)
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

COMMENT ON COLUMN RED.PUNTO.NOMBRE_PARA_TGN IS 'Nombre asignado al punto por TGN. Debe coincidir en todo (sensible a maYúScULas)';

COMMENT ON COLUMN RED.PUNTO.ID_CAMARA_VIRTUAL IS 'Identificador de la cámara (virtual) a la que pertenece el punto';

COMMENT ON COLUMN RED.PUNTO.CAMARA_NOMINADA IS 'Indica si el punto es una cámara nominada';

COMMENT ON COLUMN RED.PUNTO.ID_PROVINCIA IS 'Provincia del punto que corresponde a los clientes que les provee consumo. Puede o no coincidir con la provincia fisica de la provincia';


CREATE UNIQUE INDEX RED.PK_PUNTO ON RED.PUNTO
(ID_PUNTO)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX RED.UK_PUNTO_CODIGO ON RED.PUNTO
(CODIGO)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX RED.UK_PUNTO_NEMONICO ON RED.PUNTO
(NEMONICO)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX RED.UK_PUNTO_NOMBRE_PARA_TGN ON RED.PUNTO
(NOMBRE_PARA_TGN)
LOGGING
NOPARALLEL;


CREATE OR REPLACE TRIGGER RED.BI_ID_PUNTO BEFORE INSERT ON RED.PUNTO REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
BEGIN
SELECT RED.SEQ_ID_PUNTO.NEXTVAL INTO :NEW.ID_PUNTO FROM DUAL;
END BI_ID_PUNTO;
/


ALTER TABLE RED.PUNTO ADD (
CONSTRAINT CHK_PUNTO_TELEMEDIDA_SN
CHECK (TELEMEDIDA IN ('S', 'N')),
CONSTRAINT NN_PUNTO_CAMARA_NOMINADA
CHECK ("CAMARA_NOMINADA" IS NOT NULL),
CONSTRAINT NN_CODIGO_PUNTO
CHECK (CODIGO IS NOT NULL),
CONSTRAINT NN_NEMONICO_PUNTO
CHECK (NEMONICO IS NOT NULL),
CONSTRAINT NN_ID_TIPO_PUNTO_PUNTO
CHECK (ID_TIPO_PUNTO IS NOT NULL),
CONSTRAINT CHK_PUNTO_CAMARA_NOMINADA_SN
CHECK (CAMARA_NOMINADA IN ('S', 'N')),
CONSTRAINT NN_PUNTO_ID_PUNTO
CHECK (ID_PUNTO IS NOT NULL),
CONSTRAINT PK_PUNTO
PRIMARY KEY
(ID_PUNTO),
CONSTRAINT UK_PUNTO_NEMONICO
UNIQUE (NEMONICO),
CONSTRAINT UK_PUNTO_NOMBRE_PARA_TGN
UNIQUE (NOMBRE_PARA_TGN),
CONSTRAINT UK_PUNTO_CODIGO
UNIQUE (CODIGO));

ALTER TABLE RED.PUNTO ADD (
CONSTRAINT FK_PUNTO_PUNTO
FOREIGN KEY (ID_CAMARA_VIRTUAL)
REFERENCES RED.PUNTO (ID_PUNTO),
CONSTRAINT FK_PUNTO_PROVINCIA
FOREIGN KEY (ID_PROVINCIA)
REFERENCES RED.PROVINCIA (ID_PROVINCIA),
CONSTRAINT FK_PUNTO_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA),
CONSTRAINT FK_PUNTO_ID_TIPO_PUNTO
FOREIGN KEY (ID_TIPO_PUNTO)
REFERENCES RED.TIPO_PUNTO (ID_TIPO_PUNTO),
CONSTRAINT FK_PUNTO_ID_GASODUCTO
FOREIGN KEY (ID_GASODUCTO)
REFERENCES RED.GASODUCTO (ID_GASODUCTO));

GRANT SELECT ON RED.PUNTO TO BALANCE WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO CI WITH GRANT OPTION;
GRANT QUERY REWRITE ON RED.PUNTO TO CI;

GRANT SELECT ON RED.PUNTO TO DEGNET WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO DEG_SCADA WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO DESPACHO WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO ENARGAS WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO L_AE;

GRANT SELECT ON RED.PUNTO TO L_CI;

GRANT SELECT ON RED.PUNTO TO L_DESPACHO;

GRANT DELETE, INSERT, UPDATE ON RED.PUNTO TO LE_DESPACHO;

GRANT SELECT ON RED.PUNTO TO L_GAF_A;

GRANT SELECT ON RED.PUNTO TO L_GAF_F;

GRANT SELECT ON RED.PUNTO TO LITORAL WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO PRODUCTOR WITH GRANT OPTION;

GRANT REFERENCES ON RED.PUNTO TO PUBLIC;

GRANT SELECT ON RED.PUNTO TO SIC WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO TGN WITH GRANT OPTION;

GRANT SELECT ON RED.PUNTO TO TGS WITH GRANT OPTION;

ALTER TABLE TGN.NOMINACION_GAS ADD (
CONSTRAINT FK_NOM_GAS_PUNTO
FOREIGN KEY (ID_PUNTO_RECEPCION)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.NOMINACION_PUNTO ADD (
CONSTRAINT FK_NOMINACION_PUNTO_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.GAS_LINK ADD (
CONSTRAINT FK_GAS_LINK_ID_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.CALIDAD_GAS ADD (
CONSTRAINT FK_CALIDAD_GAS_ID_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.ABI_COMP_AUT ADD (
CONSTRAINT FK_ABI_COMP_AUT_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.ABI_COMP_ASIG ADD (
CONSTRAINT FK_ABI_COMP_ASIG_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.COMPENSACION_CLIENTE ADD (
CONSTRAINT FK_COMPENSACION_CLTE_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.REFERENCIA_PRIMARIA ADD (
CONSTRAINT FK_REF_PRIM_PUNTO
FOREIGN KEY (ID_PUNTO_REINYECCION)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.GAS_LINK_GAS ADD (
CONSTRAINT FK_GAS_LINK_GAS_PUNTO_RECEP
FOREIGN KEY (ID_PUNTO_RECEPCION)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGN.COMPENSACION_ASIGNADO ADD (
CONSTRAINT FK_COMPENSACION_ASIG_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE TGS.NOMINACION_PUNTO ADD (
CONSTRAINT FK_NOMINACION_PUNTO_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGS.SPAC_ASIGNACION_PUNTO ADD (
CONSTRAINT FK_SPAC_ASIG_PUNTO_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGS.SPAC_AUTORIZACION_PUNTO ADD (
CONSTRAINT FK_SPAC_AUT_PUNTO_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE TGS.SPAC_NOMINACION_PUNTO ADD (
CONSTRAINT SPAC_NOMPTO_REF_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE PRODUCTOR.INYECCION ADD (
CONSTRAINT FK_INYECCION_ID_PUNTO
FOREIGN KEY (ID_PUNTO)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE DESPACHO.NOMINACION_GAS ADD (
CONSTRAINT FK_NOMINACION_GAS_PUNTO
FOREIGN KEY (ID_PUNTO_RECEPCION)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE DESPACHO.NOMINACION_ENTREGA ADD (
CONSTRAINT FK_NOM_ENTREGA_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE DESPACHO.TRANSACCION_VENTA_TRANSPORTE ADD (
CONSTRAINT FK_TRANS_VENTA_TTE_PUNTO
FOREIGN KEY (ID_PUNTO_ENTREGA)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE RED.MEDICION_HORA_CAMARA ADD (
CONSTRAINT FK_MHC_ID_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE RED.LOCALIDAD ADD (
CONSTRAINT FK_LOCALIDAD_ID_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE CI.CESION ADD (
CONSTRAINT FK_CESION_ID_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE CI.SUMINISTRO ADD (
CONSTRAINT FK_SUMINISTRO_ID_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE DEGNET.NOMINACION_GAS ADD (
CONSTRAINT FK_ID_PUNTO_RECEPCION
FOREIGN KEY (ID_PUNTO_RECEPCION)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE BALANCE.CAM_CAMARA_BALANCE ADD (
CONSTRAINT CAM_CAMARA_REF_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));

ALTER TABLE BALANCE.CONSUMO_CAMARA ADD (
CONSTRAINT CONSUMO_CAMARA_REF_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));


ALTER TABLE DEG_SCADA.RTU ADD (
CONSTRAINT FK_RTU_CAMARA
FOREIGN KEY (ID_CAMARA)
REFERENCES RED.PUNTO (ID_PUNTO));


and


CREATE TABLE RED.ZONA
(
ID_ZONA NUMBER(4) CONSTRAINT NN_ZONA_ID_ZONA NOT NULL,
NEMONICO VARCHAR2(3 BYTE),
NOMBRE VARCHAR2(50 BYTE),
ROL CHAR(1 BYTE),
ID_DISTCO NUMBER(4),
CODCUENCA CHAR(2 BYTE)
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

COMMENT ON TABLE RED.ZONA IS 'Contiene las zonas (más específico que las cuencas).';

COMMENT ON COLUMN RED.ZONA.ID_ZONA IS 'Código identificatorio único dentro del Degas de la zona';

COMMENT ON COLUMN RED.ZONA.NEMONICO IS 'Nemónico (3 letras) de la zona';

COMMENT ON COLUMN RED.ZONA.NOMBRE IS 'Nombre completo (descriptivo) de la zona.';

COMMENT ON COLUMN RED.ZONA.ROL IS 'Rol de la zona. (E)ntrega o (R)ecepción.';

COMMENT ON COLUMN RED.ZONA.ID_DISTCO IS 'Distribuidora que opera esa zona';

COMMENT ON COLUMN RED.ZONA.CODCUENCA IS 'Código asignado por el ENARGAS a la cuenca.';


CREATE UNIQUE INDEX RED.PK_ZONA ON RED.ZONA
(ID_ZONA)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX RED.UK_ZONA_NEMONICO ON RED.ZONA
(NEMONICO)
LOGGING
NOPARALLEL;


CREATE OR REPLACE TRIGGER RED.BI_ZONA
BEFORE INSERT
ON RED.ZONA REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT RED.SEQ_ID_ZONA.NEXTVAL
INTO :NEW.ID_ZONA
FROM dual;
END BI_ZONA;
/


ALTER TABLE RED.ZONA ADD (
CONSTRAINT NN_ZONA_ID_ZONA
CHECK (ID_ZONA IS NOT NULL),
CONSTRAINT CHK_ZONA_ROL
CHECK (ROL IN ('R', 'E')),
CONSTRAINT NN_ZONA_ROL
CHECK (ROL IS NOT NULL),
CONSTRAINT PK_ZONA
PRIMARY KEY
(ID_ZONA),
CONSTRAINT UK_ZONA_NEMONICO
UNIQUE (NEMONICO));

ALTER TABLE RED.ZONA ADD (
CONSTRAINT FK_ZONA_ID_DISTCO
FOREIGN KEY (ID_DISTCO)
REFERENCES RED.DISTRIBUIDORA (ID_DISTRIBUIDORA));

GRANT SELECT ON RED.ZONA TO CI WITH GRANT OPTION;

GRANT SELECT ON RED.ZONA TO DEGNET WITH GRANT OPTION;

GRANT SELECT ON RED.ZONA TO DESPACHO WITH GRANT OPTION;

GRANT SELECT ON RED.ZONA TO L_AE;

GRANT SELECT ON RED.ZONA TO L_CI;

GRANT SELECT ON RED.ZONA TO L_DESPACHO;

GRANT DELETE, INSERT, UPDATE ON RED.ZONA TO LE_DESPACHO;

GRANT SELECT ON RED.ZONA TO L_GAF_A;

GRANT SELECT ON RED.ZONA TO L_GAF_F;

GRANT SELECT ON RED.ZONA TO LITORAL WITH GRANT OPTION;

GRANT SELECT ON RED.ZONA TO PRODUCTOR WITH GRANT OPTION;

GRANT REFERENCES ON RED.ZONA TO PUBLIC;

GRANT SELECT ON RED.ZONA TO TGN WITH GRANT OPTION;

GRANT SELECT ON RED.ZONA TO TGS WITH GRANT OPTION;

GRANT DELETE, INSERT, SELECT, UPDATE ON RED.ZONA TO TRANSPORTE WITH GRANT OPTION;

ALTER TABLE TGN.ABI_POOL ADD (
CONSTRAINT FK_ABI_POOL_ID_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGN.NOMINACION_GAS ADD (
CONSTRAINT FK_NOMINACION_GAS_ZONA
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGN.REFERENCIA_PRIMARIA ADD (
CONSTRAINT FK_REFERENCIA_PRIMARIA_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE TGS.SPAC_AUTORIZACION_ZONA ADD (
CONSTRAINT FK_SPAC_AUT_ZONA_RECEPCION
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA),
CONSTRAINT FK_SPAC_AUT_ZONA_ENTREGA
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGS.SPAC_DESBALANCE_POR_ZONA_RX ADD (
CONSTRAINT FK_SPAC_DESB_POR__ZONA_RX
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGS.SPAC_AJUSTE_RTP_COMBUSTIBLE ADD (
CONSTRAINT FK_SPAC_AJUSTE_RTP_COMB_ZONA
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGS.SPAC_TRANSFERENCIA ADD (
CONSTRAINT FK_SPAC_TRANSFERENCIA_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGS.SPAC_NOMINACION_ZONA ADD (
CONSTRAINT FK_SPAC_NOM_ZONA_RECEPCION
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA),
CONSTRAINT FK_SPAC_NOM_ZONA_ENTREGA
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGS.SPAC_CONTRATO_RUTA ADD (
CONSTRAINT FK_SPAC_CONTRATO_RUTA_ZONA_R
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA),
CONSTRAINT FK_SPAC_CONTRATO_RUTA_ZONA_E
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE TGS.NOMINACION_ZONA ADD (
CONSTRAINT FK_NOMINACION_ZONA_RECEPCION
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA),
CONSTRAINT FK_NOMINACION_ZONA_ENTREGA
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE DEGNET.ASIGNACION_GAS_CLIENTE ADD (
CONSTRAINT FK_ASIG_GAS_CLIENTE_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE DEGNET.GAS_A_INYECTAR ADD (
CONSTRAINT FK_ID_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE DEGNET.NOMINACION_GAS ADD (
CONSTRAINT FK_NOMINACION_GAS_ID_ZONA_ENT
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE PRODUCTOR.CONTRATO ADD (
CONSTRAINT FK_CONTRATO_ID_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE PRODUCTOR.CONSUMO_CATEGORIA ADD (
CONSTRAINT FK_ZONA_CONSUMO_CATEGORIA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE PRODUCTOR.SEGMENTO_PRECIO_MES ADD (
CONSTRAINT FK_ZONA_SEGMENTO_PRECIO_MES
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE TRANSPORTE.RUTA ADD (
CONSTRAINT FK_RUTA_ID_ZONA_ENTREGA
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA),
CONSTRAINT FK_RUTA_ID_ZONA_RECEPCION
FOREIGN KEY (ID_ZONA_RECEPCION)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE DESPACHO.DCG_INYECCION_OPERATIVA ADD (
CONSTRAINT FK_DCG_INY_OP_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE DESPACHO.NOMINACION_GAS ADD (
CONSTRAINT FK_NOMINACION_GAS_ZONA
FOREIGN KEY (ID_ZONA_ENTREGA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE DESPACHO.REVENTA_GAS_CLIENTE_CLIENTE ADD (
CONSTRAINT FK_REVENTA_GAS_CLTE_CLTE_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE DESPACHO.REVENTA_GAS_CLIENTE ADD (
CONSTRAINT FK_REVENTA_GAS_CLTE_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE DESPACHO.REVENTA_GAS_BROKER ADD (
CONSTRAINT FK_REVENTA_GAS_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE RED.PUNTO ADD (
CONSTRAINT FK_PUNTO_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE RED.LOCALIDAD ADD (
CONSTRAINT FK_LOCALIDAD_ID_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));


ALTER TABLE CI.GNC_CONTRATO_GAS ADD (
CONSTRAINT FK_CONTRATO_GAS_GNC_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));

ALTER TABLE CI.GNC_DESBALANCE ADD (
CONSTRAINT FK_GNC_DESBALANCE_ZONA
FOREIGN KEY (ID_ZONA)
REFERENCES RED.ZONA (ID_ZONA));


Whe using the DataSetWizard, the column ZONA.ID_ZONA is to a System.32 and PUNTO.ID_ZONA System.Decimal.
Both columns are defined as NUMBER(4) so i think system32 should be correct.
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Postby Shalex » Fri 19 Jun 2009 15:08

Please specify the version of dotConnect for Oracle you use. Have you tried the latest 5.20.33 one? Does the problem persist in the latest version?
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Here is the info from the VS 2008

Postby degas » Fri 19 Jun 2009 15:24

Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Professional

Microsoft Visual C# 2008 91605-270-0943104-60637
Microsoft Visual C# 2008

Microsoft Visual Studio 2008 Tools for Office 91605-270-0943104-60637
Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Web Developer 2008 91605-270-0943104-60637
Microsoft Visual Web Developer 2008

AnkhSVN - Subversion Support for Visual Studio 2.0.6347.433
AnkhSVN - Subversion Support for Visual Studio 2.0.6347.433
* Ankh.Package 2.0.6347.433
* Subversion 1.5.6 via SharpSvn 1.5006.1136.36280

AnkhSVN is linked to: Apr 1.3.3, Apr-util 1.3.4, Neon 0.28.3, OpenSSL 0.9.8j 07 Jan 2009, serf 0.3.1, Subversion 1.5.6-SharpSvn-tag-1.5.6@36280, ZLib 1.2.3
AnkhSVN is dynamically linked to: Cyrus Sasl 2.1.22
AnkhSVN is optionally linked to: Berkeley DB 4.4.20, SharpPlink 1.5006.1136.36280

CodeRush for Visual Studio 3.2

CollabNet Desktop Office Integration 1.4.0.0
Provides integration to Microsoft Office Documents

CollabNet Desktop Subversion 1.4.0.0
CollabNet Desktop Subversion Integration

CollabNet Enterprise Edition 1.4.0.0
CollabNet Enterprise Edition Integration

CollabNet Site Browser 1.4.0.0
Tool Window to browse CollabNet sites

CollabNet TeamForge 1.4.0.0
CollabNet TeamForge

CollabNet Teamforge Lab Management 1.4.0.0
Provides access to Lab Management sites within CollabNet Site Browser

Devart dotConnect for Oracle 5.20.33.0
Devart dotConnect for Oracle
Copyright 2002 - 2009 Devart. All rights reserved.
Web: www.devart.com/dotconnect/oracle
Support: dcoracle@devart.com

Devart Entity Developer 2.0.21.0
Devart Entity Developer for dotConnect
Copyright © 2008-2009 Devart. All rights reserved.
Web: www.devart.com/entitydeveloper
Support: support@devart.com

Devart OraDeveloper Tools 2.55
Devart OraDeveloper Tools
Copyright 2004 - 2009 Devart. All rights reserved.
Web: www.devart.com/oradevtools
Support: oradev@devart.com

DXCore for Visual Studio 3.2
DXCore for Visual Studio

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/944899.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282) KB945282
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040) KB946040
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308) KB946308
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344) KB946344
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581) KB946581
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947171.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173) KB947173
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947180.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540) KB947540
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789) KB947789
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948127.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB952241) KB952241
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/952241.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/953256.

Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140
This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945140.

OpenCollabNet Search 1.4.0.0
OpenCollabNet Search Integration

Refactor! for Visual Studio 3.2
Refactor! for Visual Studio

DevExpress Tools
DXCore extensibility layer for Visual Studio .NET, from Developer Express, Inc. (www.devexpress.com).
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Postby Shalex » Mon 22 Jun 2009 08:29

I cannot reproduce the problem. It is mapped to System.Int32 in both cases.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Manually solved

Postby degas » Mon 22 Jun 2009 13:59

i have managed to solve this problem by manually changing this on the DataSet it self, once is generated.
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina


Return to dotConnect for Oracle