My Oracle Support Banner

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

Last updated on MARCH 05, 2024

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
 Open SQL Developer
 Connect to the WCC schema
 Enable DBMS Output for the connection
 Enter the PL/SQL Script 
 Using a CURSOR to find documents in GENWWW and create a batch file to resubmit for conversion
 Using the CURSOR to populate multiple fields
 Copy output to text file and run using IdcCommand


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