My Oracle Support Banner

How to Build IdcCommand Files and Batch Files Using SQL Developer (Doc ID 1399562.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Goal

Building batch files can be done using various tools, like Java, VisualBasic, or any language that can write to a file. Using SQL Developer, batch files can be quickly created for use with IdcCommand or BatchLoader. 

Solution

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
Goal
Solution
 Connect to a schema
 Enable DBMS Output for the connection
 Enter the PL/SQL Script 
 Copy output to text file and run using IdcCommand
 Sample Output
 Using a cursor to find documents in GENWWW and create a batch file to resubmit for conversion


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