OWB 11.2 Design Center Implementation Window of Package, Function or Procedure is Sometimes Reset to the Default Code (Doc ID 1337877.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

In the OWB 11.2 Design Center, the Implementation window of a Package, Function or Procedure is sometimes reset to the default code.

When this happens e.g. to a Procedure the following default code is visible in the implementation:

--initialize variables here

-- main body
BEGIN
NULL; -- allow compilation

RETURN NULL;
EXCEPTION
WHEN OTHERS THEN
NULL; -- enter any exception code here
RETURN NULL;
END;

Cause

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 hundreds of Community platforms