Hi,

I am trying to connect to the external DB and import some tables. When I try to publish it throws the error on a foreign key because the primary key are mapped to text datatype in plugin with 168 as length, when I asked for DLL from DBA; the primary key column is defined as NUMBER NOT NULL. What should be the equivalent datatype in plugin for this column so that foreign keys are mapped correctly?

Thanks.

Hi,

Which is the size of number? because it depends on that. You can check on this page what should be the equivalent from Oracle to Outsystems.

Regards,

Marcelo

Hi,

Problem is there no size mentioned in DLL. DLL for one table is as below

CREATE TABLE DBA.Table
(
  AGP_ID  NUMBER                                      NOT NULL,
  some other columns
)

HI,

Text is the correct one. Which error are you getting?

Regards,

Marcelo

Hi,

Getting the error on foreign key column "Invalid Data Type: 'EntityIdentifier' data type required instead of 'Text'.". For example: with below example it is throwing error on column AGP_ID_FK
  AGP_ID         TEXT
  AGP_ID_FK  Table Identifier 

Thanks.

Solution

Had to remove the foreign key from the plugin, then I was able successfully publish it.

Solution