tethys
Member
Hi
We are (unfortunately) still using JDE B7334 with an Oracle 11G1 database. We are currently implementing a mobile application and we have a new table that acts as an interface between JDE and the mobile app. The application requires a Notes field which we would like to be at least 4000 characters.
When we generate the table in JDE, the column in the Oracle table is generated as data type LONG.
In the data dictionary it is currently defined as Data type 20 (Variable String), Size 4000, Class VARLEN.
Long data types in Oracle are very difficult to manage in SQL because they cannot be parsed.
Does anyone know if there is a way to force JDE to generate the table with a different data type (VARCHAR2 or CLOB)?
Thanks, Paula
JDE 8.0, Oracle 11G1, AIX
We are (unfortunately) still using JDE B7334 with an Oracle 11G1 database. We are currently implementing a mobile application and we have a new table that acts as an interface between JDE and the mobile app. The application requires a Notes field which we would like to be at least 4000 characters.
When we generate the table in JDE, the column in the Oracle table is generated as data type LONG.
In the data dictionary it is currently defined as Data type 20 (Variable String), Size 4000, Class VARLEN.
Long data types in Oracle are very difficult to manage in SQL because they cannot be parsed.
Does anyone know if there is a way to force JDE to generate the table with a different data type (VARCHAR2 or CLOB)?
Thanks, Paula
JDE 8.0, Oracle 11G1, AIX