ATP adapter - can it return id after inserting record
Instead of making 2 calls to ATP
- Insert record into table
- Get Id of the record
Can this be achievable in a single ATP call
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
Version (include the version you are using, if applicable):