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 188.8.131.52 and later
Information in this document applies to any platform.
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 :
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.
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