How to update datetime array from matlab to oracle database with multiple where clause

1 view (last 30 days)
i have an 3-d datetime array and want to update the same in ORCALE table.
arr1=[19-Apr-2019 06:00:00 , 19-Apr-2019 00:00:00 , 19-Apr-2019 00:00:0, 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00]
arr2=array2table(arr1, 'VariableNames',{'HORIZ','DY1EN','DY1EX','DY2EN','DY2EX','DY3EN','DY3EX','SH1EN','SH1EX'.....
'SH2EN'});
where=['where HORIZ=' datestr(arr1) 'AND EQUIP_ID=' num2str(q)];
col={'HORIZ','DY1EN','DY1EX','DY2EN','DY2EX','DY3EN','DY3EX','SH1EN','SH1EX'.....
'SH2EN'};
update(conn,'SM',col,arr2,where);
i am getting error as "Input structure must contain fields of type double or cell"
>>

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!