Friends,
While trying to run a job to load data from a source table to a staging table, I encountered the following error:
"LOAD_PS_RBT_ACCOUNT..Transform_PS_RBT_ACCOUNT: Oracle Error - OCI_INVALID_HANDLE"
LOAD_PS_RBT_ACCOUNT is the job name. Transform_PS_RBT_ACCOUNT is the transformation name.
I could understand that this is a Oracle related error. But I wanted to know the reason for this error and any mitigations.
Cheers,
Mohan
Oracle Error - OCI_INVALID_HANDLE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 66
- Joined: Tue Dec 07, 2004 12:48 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's a connectivity error. The "handle" (a variable used in the OCI to manage the connection or the statement) is invalid. Possible causes include improperly specifying the connection string or database name, or a connection that has been lost since first being connected - that is, a network failure.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hkotze wrote:CLOB fields are supported up to 2 Gig as per Oracle OCI
Yes but this is a terrible idea to move that much data on a row using DataStage. Numbers and letters are what ETL tools are meant to handle. Think a moment about moving a gigabyte of data as a single row. Your tool is written to allow you maximum flexibility to parse and manipulate strings of data. Even if the tool can do it (DS can't), you're talking about 1 row an hour of performance. Processing is a factor of characters per second, not rows.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle