App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  CLOB retrieved as empty from Oracle DB

    Posted Sun July 14, 2024 10:47 AM

    I am calling a procedure with a CLOB out parameter and other varchar parameters, when calling the SP through ACE I am getting '' for the CLOB parameter, although it retrieves data on the SQL developer tool for this parameter, I have checked the Unicode of odbc file it's utf-8 and I did the same scenario on another environment with the same configuration of ODBC but with different DB, the data retrieved at the CLOB parameter successfully.




    ------------------------------
    hassan sheta
    ------------------------------


  • 2.  RE: CLOB retrieved as empty from Oracle DB

    Posted Mon August 26, 2024 08:23 PM

    CLOB  will always be implicitly treated as CHARACTER in IBM ACE esql environment..



    ------------------------------
    Bikramjit Purkayastha
    ------------------------------

    Original Message


Related Content