DSXchange

I am trying to do 2 activities after a job runs successfully. I am putting those 2 statements in the After tab of the oracle stage. One is an Update statement and other one is calling a stored procedure. Though I am trying to update a different table after my main job is done. The SQL statement runs fine in Toad. It is kind of something below:

UPDATE DA.XXXTable
SET LAST_UPDATE_DT = TRUNC(SYSDATE)
WHERE TABLE_NAME = 'MYXXXTable';
call #pMySchema#.SomeStoredProcedure();

Though the job finishes successfully,in the log error shows up. See below

MyTableDB.MYXXXTable: ORA-00900: invalid SQL statement

Can I do 2 activities in the After tab?
Any response is appreciated. Thanks.

No. But you could build the two into a single stored procedure.