Question

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

  • 18 March 2021
  • 1 reply
  • 2 views
S
Badge +1

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
Badge +2

@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!

Reply


Community Stats

28,715
Posts
109,490
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.