This discussion is archived
5 Replies Latest reply: Mar 4, 2013 5:12 AM by BillyVerreynne RSS

ORA-29913: error in executing ODCIEXTTABLEOPEN callou

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

Legend

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