Layer7 API Management

 View Only
  • 1.  Convert blob to string

    Posted Mar 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 Apr 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 Apr 15, 2019 01:10 PM

    Thanks Michael.

     

    Regards,

    Pramod Talekar