Question

VARCHAR2(2000) issue

  • 29 January 2018
  • 4 replies
  • 9 views
R
Badge

Hi All,

We are converting Oracle spatial(SDO Geometry) to ESRI SDE (ST Geometry) using FME. In my data, some feature classes having VARCHAR2(2000) attribute columns. Those feature classes I am not able to process. Once I change VARCHAR2(2000) to NCLOB it worked for me. But i need to completed process with VARCHAR2(2000) only. Could anyone can help on this?

4 replies

oscard
Rank
Userlevel 2
Badge +19
Could you show us how you have set the varchar(2000) in the writer? Being an ESRI SDE I guess you have created a char with 2000 for width.

 

 

erik_jan
Rank
Userlevel 2
Badge +16

Could you use VARCHAR2(2000) instead? VARCHAR is an old and limited data type and should not be used.

R
Badge
Could you show us how you have set the varchar(2000) in the writer? Being an ESRI SDE I guess you have created a char with 2000 for width.

 

 

Hi @oscard, I am creating feature class first with required columns using PythonCaller and arcpy.CreateFeatureclass_management. Then i am using this feature class in writer.

 

R
Badge

Could you use VARCHAR2(2000) instead? VARCHAR is an old and limited data type and should not be used.

Hi @erik_jan, I am using VARCHAR2(2000) only, it was a typo error. I will correct it. Thank you.

 

Reply


Community Stats

28,716
Posts
109,493
Replies
36,561
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.