My Oracle Support Banner

Using XML as External Database with dp_drop_on_connect Flag Set Doesn't Drop the External Tables (Doc ID 2760184.1)

Last updated on JUNE 14, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


An Oracle Data Integrator (ODI) XML Data Server has been configured to use an external database with dp_drop_on_connect parameter set to True.

When testing the XML Data Server from ODI Studio > Topology the first time, it is observed the tables are created in the external database.

Subsequent runs of the test connection from the XML topology do not show the timestamps of the table being updated, and the tables are not dropped. It behaves as if the data is placed in some cache and the test doesn't connect to the XML file. 

If the Agent is restarted, then the data of the XML file is loaded in the system.

The same behavior is experienced when running a procedure which uses the following two XML driver commands:





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

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

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