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
Hi,
this is an invalid error-message, just ignore it.
By default new connections are in autoCommit mode (ie each statement gets committed automatically), but maybe the commit is neccessary. So what happens if you put
into the SQL field?
regards,
/Ole
eviware.com
this is an invalid error-message, just ignore it.
By default new connections are in autoCommit mode (ie each statement gets committed automatically), but maybe the commit is neccessary. So what happens if you put
insert into xxx.temp_table (MY_FIELD) values ('?');
commit;into the SQL field?
regards,
/Ole
eviware.com