Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ATP adapter - can it return id after inserting record — Cloud Customer Connect
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

ATP adapter - can it return id after inserting record

Received Response
1
Views
1
Comments
edited Jan 3, 2022 7:03AM in Integration 1 comment

Summary:

Instead of making 2 calls to ATP

  1. Insert record into table
  2. Get Id of the record

Can this be achievable in a single ATP call

Content (required):

Hi experts,

Wanted to know is there a way to return id after inserting record into ATP table using ATP adapter.


Though it is achievable by writing a PL/SQL procedure. Please suggest if there is any direct option.


Tried with below query but it is not working.

INSERT INTO hzn_instances(request_id) VALUES(#p_reqId) returning Id into #p_instanceId


Thanks,

Shradha

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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