Layer 7 API Management

Expand all | Collapse all

Convert blob to string

Jump to Best Answer
  • 1.  Convert blob to string

    Posted 03-27-2019 04:01 PM

    Hello, 

     

    I need to fetch a blob data type column but the query response comes like  [@45a61f32.

    I tried using UNCOMRESS (columnName) in the query , but it's not working.

     

    Can you please suggest.

     

    Regards,

    Pramod



  • 2.  Re: Convert blob to string
    Best Answer

    Posted 04-12-2019 01:22 PM

    If this is an Oracle db , the following article might help
    https://stackoverflow.com/questions/828650/how-do-i-get-textual-contents-from-blob-in-oracle-sql
    Regards
    .....Michael



  • 3.  Re: Convert blob to string

    Posted 04-15-2019 01:10 PM

    Thanks Michael.

     

    Regards,

    Pramod Talekar