This might be another dumb question ..
Should a standard insert statement end with a semicolon in Boomi? I have tried with and without ..
I am asking this question as the insert doesn't seem to occur on the database and no try catch is raised ..
I have tried both standard and dynamic type of statements..
I can get the captured SQL and it looks fine and runs fine if pasted to Oracle SQL*Plus ..
Note : a connection SQL can be captured to a file (for debug purposes ... turn off for prod ..) as per:
e.g. An example of the insert statement generated is as per:
INSERT INTO OFM.WELL_CMPLTN_DAILY_PROD
, 'PLEASANT_HILLS_36I-PLEASANT HILLS SH'