Question

When will FME support long Oracle entity names?


Badge +4

Oracle has been supporting table and column names up to 1000 chars since 19c. ArcGIS desktop 10.7.1 and Pro 2.8, and later, also support long entity names for Oracle. But the latest FME 2022.0 Oracle SDE writer still limit user attributes in the Feature Type panel to be 30 chars. This puts quite a big limitation on our table design. Hope FME can accommodate long Oracle entity names soon.


2 replies

Userlevel 2
Badge +9

Are you using the Oracle Writer or the SDE Writer in this case?

Oracle has stated that users should use CLOB and NCLOB datatypes instead of LONG, which has since been deprecated. These are currently supported by the Oracle/Oracle Spatial Object Writer. You could also try the JDBC Writer if you need to write LONG data types.

Badge +4

Are you using the Oracle Writer or the SDE Writer in this case?

Oracle has stated that users should use CLOB and NCLOB datatypes instead of LONG, which has since been deprecated. These are currently supported by the Oracle/Oracle Spatial Object Writer. You could also try the JDBC Writer if you need to write LONG data types.

@danminneyatsaf​ I was referring the table and column name limitations. Both Oracle and ArcGIS 10.7.1 and Pro 2.8 have expanded the infamous 30 char length limitation in table/column names for Oracle DB, but FME has not yet expanded the limitation in its non-spatial Oracle writer and Oracle SDE writer.

Reply