Unanswered: ETL problem using Oracle Warehouse Builder 3i (Oracle 8.1.7)
Using Oracle Warehouse Builder 3i against an Oracle 8.1.7 database I've created a new mapping to select from a local table which is inserting into a target table in another schema on a separate instance/SID using a database link. OWB generats the code but on deploying the mapping I'm getting the following errors:
566/24 PL/SQL: Statement ignored
567/17 PL/SQL: SQL Statement ignored
567/17 PLS-00435: DML statement without BULK In-BIND cannot be used
570/19 PLS-00454: with a returning into clause, the table expression
cannot be remote or a subquery
Is there any other way of performing this type of operation against a remote table using OWB to generate the code?