Load Ingest Data
Results 1 to 4 of 4

Thread: Attunity converted from BLOB to Long Raw

  1. #1
    lsabster is offline Junior Member
    Join Date
    Oct 2006
    Posts
    29
    Rep Power
    0

    Attunity converted from BLOB to Long Raw

    Hello,

    We have a file that has a BLOB from Oracle 9.
    When we do a describe in NavSQL>, we get the column as unspecified.
    But througt hsodbc, we do another describe, and we get "Long Raw" not "BLOB".

    How come it does not show as BLOB? Please advise. Thank you.

  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    Since you are talking about RMS, there is no real blob support there. You have a big byte array in the RMS buffer (that's the Unspecified data type). From the point of view of Oracle, this is not a blob (which is stored outside of the record) but a column that is part of the record, hence LONG RAW. Anyway, what way it is exposed, it does not have the real ORACLE type semantics since it comes from a gateway.

    Practically, you should be able to use the same API (though you will have to read sequentially).
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    lsabster is offline Junior Member
    Join Date
    Oct 2006
    Posts
    29
    Rep Power
    0

    Blob

    Hello,

    Thank you for your reply, but will you please explain further.

    Does Attunity translates "BLOB" to "Long Raw" and "CLOB" to something else when Oracle requested the information and does the translation internally?

  4. #4
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    My point was that RMS (with or without AIS) does not support BLOBs (there is no such thing).

    As to what happens in a specific case, you will have to provide more details.
    What metadata you were using with Oracle 9 and how. What and how you use Oracle now and with what metadata.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •