Page 1 of 1

OCI_SUCCESS_WITH_INFO

Posted: Thu Jul 05, 2001 4:27 pm
by admin
Hi all,
i have a problem with Datastage 4.1 NT.
While im trying to import metadata from oracle an error occurs: Error - OCI_SUCCESS_WITH_INFO. This error occurs also when i try to use the viewdata utility on OCI8 Plug-in. I have the same problem with Datastage 4.0 on SUN but in this case it only happens when i try to execute a process that extracts from an oracle table and loads on another oracle table throught DBLink.

The error causes an abort.

Can anyone help me?

Thanks

Regards,

Riccardo Tani
Staff Consultant
Direzione Industria e Servizi
Datamat, Enabling Your Future
Rome, Italy
e-mail: rtani@datamat.it

Posted: Thu Jul 05, 2001 11:16 pm
by admin
SQL_SUCCESS_WITH_INFO means that the operation has succeeded but some information has been attached to the result set (for example a message about possible loss of precision). Try using an ODBC connection to import the metadata. You can view the data as part of the importation process. This will get the metadata into your repository. Others with knowledge of Oracle 8 may offer more clues on using the OCI8 stage.

Posted: Thu Jul 05, 2001 11:32 pm
by admin
Is it just one particular table that you have a problem with, or all tables?

If just one or a few, can you post the table create script? (So I can recreate it and play with it.)

Posted: Fri Jul 06, 2001 8:22 am
by admin
Thanks Ray, David,
about the problem with Datastage 4.1 on NT4.0, ive found a solution working together with DBA Oracle. (Was a oracle user problem)

Thanks again

Regars,

Riccardo Tani
Staff Consultant
Direzione Industria e Servizi
Datamat, Enabling Your Future
Rome, Italy
e-mail: rtani@datamat.it

----- Original Message -----
From: "Ray Wurlod"
To:
Sent: Friday, July 06, 2001 1:16 AM
Subject: RE: OCI_SUCCESS_WITH_INFO


> SQL_SUCCESS_WITH_INFO means that the operation has succeeded but some
> information has been attached to the result set (for example a message
about
> possible loss of precision).
> Try using an ODBC connection to import the metadata. You can view the
data
> as part of the importation process. This will get the metadata into
> your repository. Others with knowledge of Oracle 8 may offer more
> clues on
using
> the OCI8 stage.
>
>