7 Replies Latest reply: Aug 19, 2013 1:05 AM by abureem98 RSS

    ORA-29913: error in executing ODCIEXTTABLEFETCH callout

    reddy1986
      Hi guys,

      Below is the external table which i have created
      create table temp_cust_lookup 
      (kunnr_id varchar2(12),
      vkorg varchar2(6),
      parvm varchar2(4),
      kunn2 varchar2(12),
      kunnr varchar2(400),
      kunn2_1 varchar2(400)
      )
      
      organization external
      (
      type oracle_loader 
      default directory SFTP_FEEDS
      ACCESS PARAMETERS
      ( RECORDS DELIMITED BY NEWLINE
      FIELDS TERMINATED BY ',' optionally enclosed by '"'
      MISSING FIELD VALUES ARE NULL)
      LOCATION (SFTP_FEEDS:'KNVP-SAR-DEL-NAME-At_VAIO.txt')
      );
      {code}
      
      when i run a select query on this table i receive
      
      ORA-29913: error in executing ODCIEXTTABLEFETCH callout
      
      please help me with this..
      thanks