PL/SQL (MOSC)

MOSC Banner

EIT API Error

edited Mar 14, 2012 9:05AM in PL/SQL (MOSC) 3 comments

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center