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
Ryan
I used insert statement like( below ) for SQL Server 2005.. and was successful in updating the DB. readcode and readCity are test properties values read from response..
Note: 'apupdate[' is the table name.
insert into apupdate(apcode, apcity) values ('${#TestCase#readCode}','${#TestCase#readCity}')
hope this might help you...
I used insert statement like( below ) for SQL Server 2005.. and was successful in updating the DB. readcode and readCity are test properties values read from response..
Note: 'apupdate[' is the table name.
insert into apupdate(apcode, apcity) values ('${#TestCase#readCode}','${#TestCase#readCity}')
hope this might help you...