• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

_execSQLtoJSON

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • _execSQLtoJSON

    Can this function take the data type's clob or blob?

  • #2
    No, CLOBs and BLOBs are not supported in vvOut_execSQLtoJSON. If a CLOB or BLOB is detected in the select statement it will throw an error message. You must build responses containing those types of fields manually, i.e. using vvOut_Data.

    Comment


    • #3
      Basically, I would use the in-memory locator pointer for BLOB'S or Clobs and pass that pointer to vvOUT_DATA. Thanks

      Comment

      Working...
      X