Skip to main content
Question

When will FME support long Oracle entity names?


aguan
Contributor
Forum|alt.badge.img+11
  • Contributor

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

danminneyatsaf
Safer
Forum|alt.badge.img+12

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.


aguan
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • August 4, 2022
danminneyatsaf wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings