5 Replies Latest reply: Mar 4, 2013 7:12 AM by Billy~Verreynne RSS

    ORA-29913: error in executing ODCIEXTTABLEOPEN callou

    994599
      declare
      cursor curTab is select rtrim(ltrim(object_name)) tabname
      from user_objects where object_type = 'TABLE';
      rowCnt NUMBER;
      sqlStmt VARCHAR2(32627);

      begin
      for curVar in curTab
      loop
      sqlStmt := 'SELECT COUNT(*) FROM ' || curVar.tabname;
      EXECUTE IMMEDIATE sqlStmt INTO rowCnt;
      dbms_output.put_line(lpad(curVar.tabname,50,' ') || ' ' || lpad(rowCnt,30,' '));
      end loop;
      end;

      ++++++++++++++++++++++++
      ORA-29913: error in executing ODCIEXTTABLEOPEN callout
      ORA-29400: data cartridge error
      KUP-04040: file IXC.TXT in IN_WIP not found
      ORA-06512: at line 12


      ++++++++++++++++++++++++


      Please help me to resolve this