Reading LONG datatype from ORACLE
Posted: Wed Mar 08, 2006 12:54 pm
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.
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.