Forum Discussion
- omatzuraSuper ContributorHi!
Try using a DataSink instead which executes the specified SQL as a PreparedStatement (or PreparedCall if a Stored Procedure is specified). Read more at http://www.soapui.org/userguide/functio ... kstep.html
regards!
/Ole
eviware.com - Jim_CusackContributorI am having trouble using the DataSink step - I keep getting an 'Invalid Column Index' error - even though I am inserting 10 values into a table that has 10 columns
I have 1 property defined to place into the first value
Here is the SQL:
insert into ordermax.crm_om_orders(order_number, created_date, processed_date, attempts, err_msg, action, bos_po_number, submit_date, race_ack_date, race_created_date)
values (?,sysdate,sysdate,'0',null,'INS_ORDER',null,sysdate,null,null)
- SmartBear_SuppoSmartBear Alumni (Retired)Hi Jim,
could you check if the latest nightly-build fixes this? (http://www.eviware.com/nightly-builds)
let me know!
regards,
/Ole
eviware.com - Jim_CusackContributorI upgraded to version 2.5.1 Pro and the issue is resolved.
Thanks!
Related Content
- 4 years ago
- 4 years ago
- 4 years ago
- 6 years ago