Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_values.sql

Rem
Rem Copyright (c) 2000 by Oracle Corporation
Rem
Rem NAME
Rem   wb_rt_values.sql
Rem FUNCTION
Rem   Seeded values
Rem NOTES
Rem   - This file can be tested using SQL*Plus.
Rem   - OWB developers must make sure this file is also runnable
Rem     using Runtime assistant. 
Rem   - A prerequisite of seeding is this: the table being seeded
Rem     must have a primary or unique key. Otherwise, duplicate 
Rem     rows will be seeded by upgrade utility.
Rem
Rem MODIFIED
Rem  G. Watters     04/04/2002 - based on wbrtvalues.sql,
Rem                              use WB_RT_MAPAUDIT_UTIL instead of WBPRTIU,
Rem                               remove the need to populate the time series
Rem  G. Watters     10/23/2001 - Removed the need to seed the Default_Job job
Rem  Yu.Gong        04/24/2001 -  Fix bug 1741805
Rem  Yu.Gong        12/06/2000 -  Created.
Rem

BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD001','DATA FILE:');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD002','TABLE');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD003','LOADED');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD004','RECORD');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD005','ERROR');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD006','ORA-');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD007','OSD-');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD008','ROW SUCCESSFULLY LOADED');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD009','ROWS SUCCESSFULLY LOADED');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD010','ROW NOT LOADED DUE TO DATA ERRORS');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD011','ROWS NOT LOADED DUE TO DATA ERRORS');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD012','ROW NOT LOADED BECAUSE ALL WHEN CLAUSES WERE FAILED');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD013','ROWS NOT LOADED BECAUSE ALL WHEN CLAUSES WERE FAILED');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD014','ROW NOT LOADED BECAUSE ALL FIELDS WERE NULL');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD015','ROWS NOT LOADED BECAUSE ALL FIELDS WERE NULL');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD016','RUN BEGAN ON');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD017','ELAPSED TIME WAS:');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD018','TOTAL LOGICAL RECORD READ:');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD019','TOTAL LOGICAL RECORDS READ:');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD020','COLUMN');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD021','INSERT OPTION IN EFFECT');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD022','SQL*LOADER-');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN 
  WB_RT_MAPAUDIT_UTIL.SEED_STRINGS('SQLLOAD023','WHEN');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    NULL;
END;
/
BEGIN
  WB_RT_MAPAUDIT_UTIL.SEED_PARAMETER('Runtime Version','009.000.002.000.000', -1, 'N');
END;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de