You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BO Transaction

Received Response
17
Views
2
Comments
edited Apr 9, 2019 3:00AM in Visual Builder 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!