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
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.
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.
>
>
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.
>
>