Skip to main content
Question

VARCHAR2(2000) issue

  • January 29, 2018
  • 4 replies
  • 41 views
R
Forum|alt.badge.img

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

oscard
Influencer
Forum|alt.badge.img+22
  • oscardInfluencer
  • Influencer
  • January 29, 2018
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
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • January 29, 2018

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

R
Forum|alt.badge.img
  • r8
  • Author
  • January 30, 2018
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
Forum|alt.badge.img
  • r8
  • Author
  • January 30, 2018

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.

 

Community Stats

32,184
Posts
122,181
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.