apex-mle-ajax.js

/*
In case the browser asynchronously called the server via AJAX,
this is how we can handle that request in JavaScript (MLE)
*/

let response = {};
try {
    // execute any business logic here
    apex.conn.execute(…);
    // dummy response
    response = {
        status: 'success',
        anArray: [1, 2, 3],
        nestedObject: {
            simple: 'nesting'
        }
    };
    // JSON operations are trivial
    response.nestedObject.simple = 'alteration';
} catch(e) {
    // in case of any errors, rollback any changes
    // and inform the browser of the error if in debug mode
    apex.conn.rollback();
    response.status = 'error';
    if(apex.env.debug != 'NO'){
        response.message = e.ORACLE_ERROR_MSG;
    }
}

// sending the response back to the browser
apex.conn.execute('begin sys.htp.p(:1); end;', [JSON.stringify(response)]);