1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Loading blob data to .txt file

Discussion in 'Oracle Apps Technical' started by Bharat, Nov 1, 2015.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi All,

    We are trying to load blob data to .txt files, but no data is writing to the file when we open it. We had observed that line size it accepting is 1024 and we are getting more than that. can anyone please suggest us how to handle this.

    We are on Oracle Apps 11i and Oracle 11g Database Version.
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    BLOB data is, by definition, binary. A txt file holds, again by definition, character/ASCII data. If you have character data you want in a text file, why are you not using a CLOB? Failing that, you can look at converting the data from binary to text using something like DBMS_LOB.CONVERTTOCLOB or UTL_RAW.CAST_TO_VARCHAR2.