My Oracle Support Banner

How to Load a Large XML File(> 32k) Into a Database Table Using XSU without Using Bfile (Doc ID 240097.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle XML SQL Utility (XSU) - Version 8.1.7.4 and later
Information in this document applies to any platform.Purpose

This article explains how to load an large XML file (greater than 32k) into a database table using the XML SQL Utility (XSU) for PL/SQL.

Scope

It is intended for XML developers, DBAs, and analysts who want to integrate XML and Oracle.

- Oracle JServer is installed
- XML-SQL (XSU) utility is installed
- Copy the test.xml file to a valid directory in your environment

NOTE: Set UTL_FILE_DIR to point to the directory containing the XML file. All users can read or write to all files specified by this parameter. Therefore all PL/SQL users must be trusted with the information in the directories specified by this parameter.

 

Details

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.