Oracle 11g and Ascential DataStage 5.2.1

[Database Administrator]

Hello,

I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.

With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.

Have anyboy seen this problem?

Thank you very much.
-Ramón

[Database Administrator]

rapaz wrote:
> Hello,
>
> I´m working in a DataWarehouse enviroment with Ascential DataStage
> 5.2.1 and Oracle 11g. We are trying to load information in a Oracle
> database using DATASTAGE jobs. Our problem is with the commit. When
> the job is runnig we dont see any rows in the database, it seems that
> DataStage dont commit any change. But we have expecified 500 rows per
> transaccion in the OCI component of the job.
>
> With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
> Jobs we are using the OCI component provided by Datastage.
>
> Have anyboy seen this problem?
>
> Thank you very much.
> -Ramón

Why don't you take this up with the company that makes the product?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org