Hi All,
I am having a column defined as "long" datatype at the Oracle source level.
I am using Oracle Enterprise Stage and not being able able to import the Metadata through Orchestrate.
Even while i am changing the data type to Longvarchar and using function To_Char at the Oracle Stage i am getting the same error.
Couldn't getting how to resolve this one.
thanks in advance.
How to handle "Long" data type defined at Oracle s
Moderators: chulett, rschirm, roy
I doubt it is supported. Check the pdf documentation for the stage. The OCI stage on the Server side - for example - lists in the 'functionality not supported' section:
![Confused :?](./images/smilies/icon_confused.gif)
So it supports CLOB and that's about it. LONG fields are a PITA just in Oracle, not sure why you'd think you would have any better luck in an ETL tool. However, maybe someone knows a 'trick'...Support of Oracle data types such as BLOB, FILE, LOB, LONG, LONG RAW, MSLABEL, OBJECT, RAW, REF, ROWID or a named data type.
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
How to handle "Long" data type defined at Oracle s
Hi Chulett,
thanks for the info.
please tell me way to find the solution.
Or Can i revert back to my superior that its not going to work with DS PX.
Hope to find some answer which i can tell me to my boss.
thanks in advance.
thanks for the info.
please tell me way to find the solution.
Or Can i revert back to my superior that its not going to work with DS PX.
Hope to find some answer which i can tell me to my boss.
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
thanks in advance.
Re: How to handle "Long" data type defined at Orac
Call Support.san_deep wrote:please tell me way to find the solution.
Are you thinking you will be doing any 'transformations' of the LONG data? If all you are doing is moving this data from one instance to another, that certainly doesn't need to be a DataStage task. As others here have said, just because DataStage is a really cool hammer, that doesn't make every problem a nail.
Talk to your DBA. They should have more appropriate suggestions on how to handle your LONG data.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers