Inserting into Oracle table as DataSink
I created a generic temp table in Oracle to make sure that I am getting a good connection, and I was able to pull data from this table. However when I try to do an insert I always get the following ...
Forum Discussion
Thanks again for the reply.
Here is my sql statement:
insert into xxx.temp_table (MY_FIELD) values (?);
commit;
The DataSink has one property which has been quoted.
Is it correct to end with semi-colons and provide the commit explicitly?
I am getting the message 'wrote data in xxms' and the error logs are clean. But the DB is still not doing the insert.
Regards
Here is my sql statement:
insert into xxx.temp_table (MY_FIELD) values (?);
commit;
The DataSink has one property which has been quoted.
Is it correct to end with semi-colons and provide the commit explicitly?
I am getting the message 'wrote data in xxms' and the error logs are clean. But the DB is still not doing the insert.
Regards