This discussion is archived
7 Replies Latest reply: Aug 18, 2013 11:05 PM by abureem98 RSS

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

reddy1986 Newbie
Currently Being Moderated
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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points