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 for the speedy replies.
The column is defined as VARCHAR2 (15 BYTE), but I think there is something else at work here. Even if I completely remove the insert statement I still get the invalid column index message.
This is my first attempt to use SoapUI so please forgive me for these next two questions that may or may not be related to this issue.
When I hit the green arrow while viewing my DataSink configuration I get the message "wrote data in xx ms", as if something has just occurred? But there is no change in what I see in the Data Log or in the actual database? And in fact I do see a value in the Value field beside the Property field, but nothing in the data log other than the Name of the property. Is this behavior correct?
Regards
RH
The column is defined as VARCHAR2 (15 BYTE), but I think there is something else at work here. Even if I completely remove the insert statement I still get the invalid column index message.
This is my first attempt to use SoapUI so please forgive me for these next two questions that may or may not be related to this issue.
When I hit the green arrow while viewing my DataSink configuration I get the message "wrote data in xx ms", as if something has just occurred? But there is no change in what I see in the Data Log or in the actual database? And in fact I do see a value in the Value field beside the Property field, but nothing in the data log other than the Name of the property. Is this behavior correct?
Regards
RH