Skip to main content
Question

Insert (writer) data into Oracle "Interval" data type field?

  • March 17, 2021
  • 1 reply
  • 35 views
ssmith_ftr
Contributor
Forum|alt.badge.img+7

Does anyone have suggestion/workaround for inserting data into Oracle "Interval" data type field?

 

I don't see any comments on FME idea. But I thought it worth asking in forum if someone had a workaround.

 

https://community.safe.com/s/idea/0874Q000000TlVCQA0/detail?smartspace=ideas-fme-server&t=1616021806783

 

 

My only thought is building a trigger on table. Use a varchar2 field and convert it into "interval" type before insert or updates. 

1 reply

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • March 17, 2021

@ssmith_ftr​ I think that is your only workaround. But, I think, FME won't be able to read back that interval data type either.

Don't forget to vote for that Idea!


Community Stats

32,070
Posts
121,777
Replies
39,698
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.