Retrieve Blob or Clob Data

Home Forums Convertigo Products Retrieve Blob or Clob Data

This topic contains 0 replies, has 1 voice, and was last updated by  guih@laposte.net 3 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #255646

    guih@laposte.net
    Participant

    Hi,

    i try to retrieve a blob or clob data from a table.

    i’ve got a connector with a simple query “select test from photo” where test is a clob data.

    i’d like to transform this clob to javascript string. If i transform this query with “select to_char(test) from photo or select dbms_lob.substr( test, 4000, 1 ) from photo” i retrieve only first 4000 chars because of varchar2 has a 4000 char limit.

    Can you help me ?

    Thanks,
    Guillaume

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.