Hello,
I'm trying to execute my mappings using either the sqlplus_exec_template.sql script or the wb_rt_api_exec.run_task directly.
None of them works for me.
For the first method I did the following:
$ sqlplus builder/builder @wb_rt_api_exec.pls
to load the package then on the sqlplus prompt:
@../rtp/sql/sqlplus_exec_template.sql builder DWH PLSQL STG_ANREDEN_MAP ',' ','
which gives me the following output:
Session altered.
Role set.
begin
*
ERROR at line 1:
ORA-04063: package body "BUILDER.WB_RT_API_EXEC" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"BUILDER.WB_RT_API_EXEC"
ORA-06512: at line 10
Using the wb_rt_api_exec.run_task I did the following:
sqlplus builder/builder @wb_rt_api_exec.pls
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 17 16:31:21 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Package created.
SQL> execute wb_rt_api_exec.run_task( DWH, PLSQLMAP, STG_ANREDEN_MAP, ',', ',', 0, 0);
BEGIN wb_rt_api_exec.run_task( DWH, PLSQLMAP, STG_ANREDEN_MAP, ',', ',', 0, 0); END;
*
ERROR at line 1:
ORA-06550: line 1, column 32:
PLS-00201: identifier 'DWH' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
DWH is my database instance
builder is the database user
stg_anreden_map is my mapping
So what am I doing wrong here?
Another problem occured when I'm trying to execte an easy mapping (source production database, filter on date, target datawarehousetable) from the OWB Control center. The following error messages occur only with a large number of datarows:
CursorFetchMapTerminationRTV20007
ORA-02068: following severe error from
ORA-03113: end-of-file on communication channel
STG_SIM_NUMMERN_MAP
Warnung
ORA-02068: following severe error from
ORA-03135: connection lost contact
CursorFetchMapTerminationRTV20007
ORA-02068: following severe error from
ORA-03113: end-of-file on communication channel
ORA-02068: following severe error from
ORA-03135: connection lost contact
Could this be a network of firewall problem? Has anybody observed this error before?
Thanks for your help!
Kind Regards
N. Doe