Re: Oracle 11g and Ascential DataStage 5.2.1

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 12 Sep 2008 06:37:15 -0700
Message-ID: <1221226635.386523@bubbleator.drizzle.com>


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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Sep 12 2008 - 08:37:15 CDT

Original text of this message