My Oracle Support Banner

JDBC Call to External Table Fails With ORA-20001,ORA-29913,ORA-06512 (Doc ID 2570398.1)

Last updated on NOVEMBER 22, 2021

Applies to:

JDBC - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Java application invokes a stored procedure that selects from an external table which calls ORACLE_LOADER, mapping an external file on the file share via a virtual directory.
During the execution, it fails with below error :

ErrorHandler -

error=ORA-20001:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout,
ORA-06512: at "<PLSQL BLock >", line 143

Calling the stored procedure from SQL*Plus works.
Calling it from this front-end application, which uses JDBC, does not. 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.