Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2008
    Posts
    3

    Unanswered: Converting Binary to Oracle Data Type

    I am attempting a data synch by loading data from Oracle to SQL Server. The data type for the column is Binary and Oracle is varchar2. What is a valid conversion function to load the data into the column. I have tried HEXTORAW and that is not working.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I am attempting a data synch by loading data from Oracle to SQL Server.
    How exactly?

    >The data type for the column is Binary and Oracle is varchar2.
    What does "binary" data actually represent?
    Why is target datatype VARCHAR2?

    >What is a valid conversion function to load the data into the column.
    Without knowing what the source data really represent, can't begin to guess at any possible solutoin.

    >I have tried HEXTORAW and that is not working.
    my car is not working.
    tell me how to make my car go.

    In the future please post fewer details to make solving the mystery more of a challenge.
    Last edited by anacedent; 06-28-11 at 15:11.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2008
    Posts
    3

    Converting Binary to Oracle Data Type

    How exactly?
    >>>I have an Oracle procedure which does an insert to the SQL Server table.

    What does "binary" data actually represent?
    >>>The data is HEX

    Why is target datatype VARCHAR2?
    >>>The target is Binary (SQL Server). The Oracle column is VARCHAR2. I cannot change the data types.

    Without knowing what the source data really represent, can't begin to guess at any possible solutoin.
    >>>The source is VARCHAR2 and the target is binary.

  4. #4
    Join Date
    Feb 2005
    Posts
    57
    Please give examples of source data. Is it in the range 0-F, 0000-FFFF or what?

  5. #5
    Join Date
    Mar 2008
    Posts
    3

    Converting Binary to Oracle Data Type

    The data ranges from NULL to 0x00.

Posting Permissions

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