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,
I'm very sorry, I think I have been giving you incorrect instructions.. The SQL statement is called as a prepared statement and must have parameters ordered as the properties in the DataSink step. Upon each execution the corresponding property-values will be assigned to the statement before it is executed.
So in your case the statement should be something like
insert into XXX.temp_table
(MY_FIELD)
values
(?)
- if MY_FIELD is a string it will need to be quoted
Make sure that the DataSink contains one property, whose value will be assigned to the ? in the statement on each run..
Hope this works a bit better, let me know!
regards,
/Ole
eviware.com
I'm very sorry, I think I have been giving you incorrect instructions.. The SQL statement is called as a prepared statement and must have parameters ordered as the properties in the DataSink step. Upon each execution the corresponding property-values will be assigned to the statement before it is executed.
So in your case the statement should be something like
insert into XXX.temp_table
(MY_FIELD)
values
(?)
- if MY_FIELD is a string it will need to be quoted
Make sure that the DataSink contains one property, whose value will be assigned to the ? in the statement on each run..
Hope this works a bit better, let me know!
regards,
/Ole
eviware.com