MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Archive for the ‘KUP-04040’ tag

How to avoid errors when querying external tables

without comments

Somebody got to my blog searching for how to find an external file. I thought about why they might be looking for that. Since the lack of a file raises an error stack, I concluded that they want to verify whether the file exists before querying it. That way, they avoid the annoying ORA-29913, ORA-29400, and KUP-04040 error stack.

I’ve added a page to describe the complete set of steps … The instructions let you avoid the error stack by verifying the existence of the file first.

Written by maclochlainn

September 28th, 2008 at 11:21 pm