Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

external table error ORA-29913: error in executing ODCIEXTTABLEOPEN callout

Sandy310Apr 29 2010 — edited Apr 29 2010
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
This post has been answered by Centinul on Apr 29 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2010
Added on Apr 29 2010
1 comment
2,490 views