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!
hmm.. you should probably quote in the SQL (and not the value itself):
insert into xxx.temp_table (MY_FIELD) values ('?')
and the commit shouldn't be neccessary.
Does that help?
/Ole
eviware.com
hmm.. you should probably quote in the SQL (and not the value itself):
insert into xxx.temp_table (MY_FIELD) values ('?')
and the commit shouldn't be neccessary.
Does that help?
/Ole
eviware.com