https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314526#M85283 Protection double quotes (") by "\" in the request.<BR />Where defined the @variables? Wed, 05 Jul 2017 17:38:49 GMT TRF 2017-07-05T17:38:49Z https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314525#M85282 Team, I'm using the below insert query to insert data into a table. But I'm getting syntax error not sure what I'm missing here, "insert into employee (emp_id,dept_id,emp_nm,emp_address,insert_date) values(@EMP_ID,(select max(dept_id) + 1 as dept_id from department),@EMP_NM,NULL,to_char(sysdate(),”DD-MM-YYYY”))” Getting error as “tOraclerow - ORA-00936 missing expression” Please help on this issue. Wed, 05 Jul 2017 16:58:41 GMT https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314525#M85282 rajesh90 2017-07-05T16:58:41Z https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314526#M85283 Protection double quotes (") by "\" in the request.<BR />Where defined the @variables? Wed, 05 Jul 2017 17:38:49 GMT https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314526#M85283 TRF 2017-07-05T17:38:49Z https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314527#M85284 Can you be more elaborate ? Basically i'm getting the columns in the flow till the tOracelrow component, I need to know what is the coding or procedure on how to access the same in the query written inside the tOraclerow component? Thu, 06 Jul 2017 10:21:17 GMT https://community.qlik.com/t5/Talend-Studio/Oracle-Insert-Using-tOracleRow/m-p/2314527#M85284 rajesh90 2017-07-06T10:21:17Z