cursor curTab is select rtrim(ltrim(object_name)) tabname
from user_objects where object_type = 'TABLE';
for curVar in curTab
sqlStmt := 'SELECT COUNT(*) FROM ' || curVar.tabname;
EXECUTE IMMEDIATE sqlStmt INTO rowCnt;
dbms_output.put_line(lpad(curVar.tabname,50,' ') || ' ' || lpad(rowCnt,30,' '));
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
i have a db and schema in dat.
now i am executing only this in SQL plus connecting to that db.
i have not mentioned the location. please let me know if i have to mention the location how will i do that.
The PL/SQL block you're trying to execute is meant to count the number of rows in each table of your schema.
Among those tables, there's one which actually is an EXTERNAL table.
An external table possesses a LOCATION attribute that tells Oracle where to find the file(s) the table is based on. In your case, Oracle expects a file named 'IXC.TXT' in directory 'IN_WIP', but apparently this file doesn't exist, hence the error you've got at runtime when Oracle tries to access the data.