AnsweredAssumed Answered

Should a standard insert statement end with a semi-colon?

Question asked by allan.ford577519 on Apr 4, 2017
Latest reply on Apr 6, 2017 by vishwamannam623297

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
(
WELL_COMPLETION_S
, WELL_COMPLETION_ID
, PRODUCTION_DATE
, ALLOCATED_GAS_VOLUME
, ALLOCATED_WATER_VOLUME
)
VALUES
(
700027531
, 'PLEASANT_HILLS_36I-PLEASANT HILLS SH'
, to_date('20161101','yyyyMMdd')
, nvl('4124.8218',null)
, nvl('',null)
) ;

Outcomes