Skip to main content
Question

Reading in Oracle Long Raw data

  • September 30, 2020
  • 1 reply
  • 86 views
A

Hi all,

 

I wondered whether anyone had come across any issues reading in data from an Oracle DB with type LONG RAW. It seems FME cannot read in data of this type and 'skips' that column when reading in an Oracle DB table.

 

Does anyone have any pearls of wisdom on how I could load this data in to my FME workflow?

 

Thanks all,

 

Amber

 

 

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    david_r
    Celebrity
    • david_rCelebrity
    • September 30, 2020

    Which version of FME is this?

    Are you using the Oracle non-spatial reader, or are you going through some middleware like ArcSDE?

    One thing to test is to use the SQLExecutor and the TO_LOB() function to cast the LONG RAW to LOB, for example:

    SELECT TO_LOB(MY_LONG_RAW_COLUMN) AS MY_LOB FROM MY_TABLE

     

    See:

    https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions185.htm

    Community Stats

    32,207
    Posts
    122,305
    Replies
    39,891
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.