Retrieve Blob or Clob Data

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


    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 ?


Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.