Hello folks,
Need help - I’m using ExecuteNonQuery activity and trying to insert data into DB. But, getting error while using it with either variable/ parameter.
“insert into O2CINTF.ZBR_AUTO_SO_LINE_UPD (ROW_ID, SO_NUM, ORD_REV_NUM, ORACLE_LINE_NUM, UOM, SHIPPING_METHOD, SHIPPING_ADDR, IMPORT_DATE, STATUS, ERR_FLAG, ERR_MSG1, ORG)
values (” + @sqlSOLIRowId + “, ‘11204715’, ‘2’, ‘1.1’, ‘’, ‘Express’, ‘1-14V7J-2891’, sysdate, ‘TEST_UPDATE’, ‘’, ‘’, ‘1-9GDC’)”
Comilation error: String constant must end with double quote
If I remove the double quotes then missing expression error comes up:
“insert into O2CINTF.ZBR_AUTO_SO_LINE_UPD (ROW_ID, SO_NUM, ORD_REV_NUM, ORACLE_LINE_NUM, UOM, SHIPPING_METHOD, SHIPPING_ADDR, IMPORT_DATE, STATUS, ERR_FLAG, ERR_MSG1, ORG)
values (@sqlSOLIRowId, ‘11204715’, ‘2’, ‘1.1’, ‘’, ‘Express’, ‘1-14V7J-2891’, sysdate, ‘TEST_UPDATE’, ‘’, ‘’, ‘1-9GDC’)”
18.4.1+Branch.master.Sha.bc66386dd8e2160b6d35f31d5ce934a5aa4cf4bd
Source: Execute Non Query
Message: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00936: missing expression
Other details:
Studio 2018.4.1 - 12/10/2018 Enterprise Edition
Microsoft Windows 10 Enterprise 64-bit
.NET Framework Version 4.7.2
Please help!