Dear Gurus,
I am trying to transfer a set of data to one column in oracle with the data type blob. When I define as a longvarchar I am getting oracle error message. So any one can help me how to handle this BLOB Data type.
Our Current version is 7.1
Thanks with Regards,
Thiruma Valavan
ORACLE BLOB Datatype
Moderators: chulett, rschirm, roy
ORACLE BLOB Datatype
Best Regards,
Thiruma Valavan
Thiruma Valavan
Change the datatype to LongVarchar and you should be able to move the data using OCI stage. I have done it successfully in the past on 7.5. Not sure on 7.1 though.
What happens when you try to import the table defintion of that particular table through Manager or Desingner? How does the datatype come into DataStage? The default was set to LongVarchar with a Length of 4000 for me when I tried to import it through Manager. Did you try doing that? Also, what is the error message you are getting?
What happens when you try to import the table defintion of that particular table through Manager or Desingner? How does the datatype come into DataStage? The default was set to LongVarchar with a Length of 4000 for me when I tried to import it through Manager. Did you try doing that? Also, what is the error message you are getting?
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
Oracle's VARCHAR2(4000) is the maximum, so you're limiting yourself to the first 4000 characters selecting and inserting. It's BLOB, so that means you're corrupting your data, since BLOB means BINARY LARGE OBJECT, the first 4000 characters of binary data is useless.
Proceed at your own risk.
Proceed at your own risk.
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
Hi Krish,
Thanks for you tips. When I imported the structure for this table, it came as LongVarChar but with out limit. When I put the structure for the Oracle9i stage. It gives me a error. I think 7.5 is good to handle this. Let me check with our vendor for this new version.
Thanks,
Thanks for you tips. When I imported the structure for this table, it came as LongVarChar but with out limit. When I put the structure for the Oracle9i stage. It gives me a error. I think 7.5 is good to handle this. Let me check with our vendor for this new version.
Thanks,
Best Regards,
Thiruma Valavan
Thiruma Valavan