Hi,
I am getting following error for external table, trying to load data in external table from a pipe delimited file.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file BIPO_04_28_2010_18_53_11.txt in AB501 not found
29913. 00000 - "error in executing %s callout"
*Cause: The execution of the specified callout caused an error.
*Action: Examine the error messages take appropriate action.
here is the code for creating table
CREATE TABLE ' || whr_ext_tab || '
(
partner_product_code VARCHAR2(30), -- Partner’s product code or part number
product_description VARCHAR2(60), -- Product description
po_comments VARCHAR2(254), -- Purchase Order Comments
wr_member_number VARCHAR2(60), -- Rewards Member Number
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "<dir>"
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
BADFILE ''BIPO.bad''
LOGFILE ''BIPO.log''
FIELDS TERMINATED BY ''|''
MISSING FIELD VALUES ARE NULL
)
LOCATION ("<dir>":''<fn>'')
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING
';
thanks
sandy