Rem
Rem $Header: a0800040.sql 17-jun-98.13:58:55 rshaikh Exp $
Rem
Rem a0800040.sql
Rem
Rem  Copyright (c) Oracle Corporation 1998. All Rights Reserved.
Rem
Rem    NAME
Rem      a0800040.sql - additional ANONYMOUS BLOCK dictionary upgrade.
Rem      		Upgrade Oracle RDBMS from 8.0.4 to the new release
Rem
Rem    DESCRIPTION
Rem
Rem      Additional upgrade script to be run during the migration of a
Rem      8.0.4 database to the new release.
Rem
Rem	 This script is called from u0800040.sql and a0800030.sql
Rem
Rem	 Put any anonymous block related changes here. 
Rem	 Any dictionary create, alter, updates and deletes  
Rem 	 that must be performed before catalog.sql and catproc.sql go 
Rem	 in c0800040.sql
Rem
Rem      The upgrade is performed in the following stages:
Rem        STAGE 1: additional steps to upgrade from 8.0.4 to 8.0.5
Rem        STAGE 2: upgrade from 8.0.5 to the new release
Rem
Rem    RETURNS
Rem 
Rem    NOTES
Rem      You must connect internal to run this script
Rem  
Rem    MODIFIED   (MM/DD/YY)
Rem    rshaikh     06/17/98 - move all anonymous block stmts from
Rem			      u0800040.sql here
Rem

Rem =========================================================================
Rem BEGIN STAGE 1: upgrade from 8.0.4 to 8.0.5
Rem =========================================================================

Rem --- NOTHING TO BE DONE HERE

Rem =========================================================================
Rem END STAGE 1: upgrade from 8.0.4 to 8.0.5
Rem =========================================================================

Rem =========================================================================
Rem BEGIN STAGE 2: upgrade from 8.0.5 to the new release
Rem =========================================================================
Rem

@@a0800050

Rem =========================================================================
Rem END STAGE 2: upgrade from 8.0.5 to the new release
Rem =========================================================================

Rem *************************************************************************
Rem END a0800040.sql
Rem *************************************************************************

