DSXchange

Hi, I am unable to execute two sql commands in before sql tab of Oracle_OCI stage. For example insert into test values('a','b'); commit; update test set ind='Y' where ind = 'N'; commit; But i am getting the below error : JobTest..Oracle_OCI_0: ORA-00900: invalid SQL statement Please let me know is i...

In the sequnnce the value of the previous stage can be overwrite for example if u r using Loop stage in the sequence u pass the list of parameters like Country US,UK. So in the job activity property u can rewrite the job parameter by clicking Loopsequence option.