BO Transaction

Content

i updating complex list.. But i want start transaction. if it failure i want rollback or commit. Should I use ORDS or BO?

ords difficult to use. Table may change over time. For example ;

BEGIN
INSERT INTO forums_nested_json_table
(device, TIME, data, signal, seqnumber, lat, lng, radius, source, status)
SELECT *
  FROM
    json_table(:body_text, '$'
        columns(
            "device" VARCHAR2(10)PATH '$.device',
            "time" NUMBER PATH '$.time',
            "data" VARCHAR2(15)PATH '$.data',
            "signal" VARCHAR2(10)PATH '$.signal',
            "seqnumber" NUMBER PATH '$.seqnumber',
            nested PATH '$.location[*]'
                columns(
                    LAT NUMBER PATH '$.lat',
                    LNG NUMBER PATH '$.lng',
                    RADIUS NUMBER PATH '$.radius',
                    SOURCE NUMBER PATH