How to delete table row using Web ADI
Hi All,
My instance details as below :
Oracle Applications : 12.2.4
Oracle RDBMS : 12.1.0.2.0
Excel Template : Microsoft Office 365
My table is as below:
CREATE TABLE XXCL_WEB_ADI_TBL
(
EMP_ID NUMBER,
EMP_NAME VARCHAR2(200 BYTE) UNIQUE,
HIRE_DATE DATE,
SALARY NUMBER,
CONSTRAINT pk_emp_id PRIMARY KEY (EMP_ID)
);
I have defined Integrator with Interface type as API - Procedure which is below.
Data in Web ADI excel template as below:
EMP_ID EMP_NAME HIRE_DATE SALARY
101 LAKSHMI 1/1/2020 2000
102 PAVAN 1/2/2020 1000
I am able to delete EMP_ID = 101 row in excel template by selecting entire row as shown in attached picture.
Requesting to tell how to write code to delete same row from XXCL_WEB_ADI_TBL table in attached procedure.