Page 1 of 1

Reading LONG datatype from ORACLE

Posted: Wed Mar 08, 2006 12:54 pm
by sonia jacob
Hi,

I need to retrieve data from a column with LONG datatype. I tried the suggestions in the forum like used varbinary. But I get the following error

main_program: Internal Error: (colDesc):orautils.C: 1714: getColDesc failed.
Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH

I also checked the dsenv for environment variables. An entry is available for "sed" and I found the same under the same path. But I could not find an entry for "dbx". I also see that this has been reported as a Datastage bug. Is there a patch available for the same now?

Is there a work around to retrieve this data from oracle, CAST, SUBSTR did not work.

Posted: Tue May 09, 2006 4:58 am
by anntaylor
Sonia,
Did you ever find an answer to this issue? I am currently running into the same problem.

Posted: Wed May 17, 2006 10:36 am
by ThilSe
Hi,

I am also facing the same error in one of my jobs when trying to ine=sert data into target DB2 table..
DB2_UDB_Enterprise_26,0: Internal Error: (group_.exportSize() <= dbquery->dataBufLength()): db2writeop.C: 985
Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH
Environment:
DS Px7.5
DB2 UDB 8.2
Aix 5

Other jobs inserting records into the same database are working fine

I appreciate your guidance in this regard

Thanks
Senthil

Posted: Wed May 17, 2006 10:54 am
by ThilSe
ThilSe wrote:Hi,

I am also facing the same error in one of my jobs when trying to ine=sert data into target DB2 table..
DB2_UDB_Enterprise_26,0: Internal Error: (group_.exportSize() <= dbquery->dataBufLength()): db2writeop.C: 985
Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH
Hi,

I get this error only when I use Write ->Append option.
When I use upsert it works fine

Thanks
Senthil