Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Writing Custom Scripts to Run Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

Removing Data from a Base Object and Supporting Metadata Tables

Removing Data from a Base Object and Supporting Metadata Tables

Use the CMXUT.CLEAN_TABLE procedure to remove all data from a base object and its supporting metadata tables. If a base object is referenced by a foreign key in another base object, then the referencing base object must be empty before you run cmxut.clean_table for the referenced base object.

Example

DECLARE IN_TABLE_NAME VARCHAR2(30); OUT_ERROR_MESSAGE VARCHAR2(1024); RC NUMBER; BEGIN IN_TABLE_NAME := 'C_BO_TO_CLEAN'; --Name of the BO table OUT_ERROR_MESSAGE := NULL; --Return msg; output parameter RC := NULL; --Return code; output parameter CMXUT.CLEAN_TABLE (IN_TABLE_NAME, OUT_ERROR_MESSAGE, RC); COMMIT; END;

0 COMMENTS

We’d like to hear from you!