EIT API Error
Dears,
I have created EIT at person level for medical information and I got an error
Following is my simple code :
----------------------------------------------------------------------------------
CREATE TABLE XXTDL_MEDICAL_DATA_TEMP
(
EMP_NO NUMBER,
PERSON_ID NUMBER,
EMP_contact_name VARCHAR2(200 BYTE),
EMP_contact_RELATION VARCHAR2(60 BYTE),
Company VARCHAR2(10 BYTE),
CLASS VARCHAR2(60 BYTE),
MED_INS_NUMBER VARCHAR2(60 BYTE),
MED_START_DATE DATE,
MED_END_DATE DATE,
UPLOAD_STATUS CHAR(1 BYTE)
)
Update XXTDL_MEDICAL_DATA_TEMP iid Set iid.UPLOAD_STATUS ='N' where iid.UPLOAD_STATUS is null;
Declare
v_person_extra_info_id number;
v_object_version_number number;
Cursor Emp_Data is Select * From XXTDL_MEDICAL_DATA_TEMP Where UPLOAD_STATUS='N'