App Connect

 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 12 days ago

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



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

    Original Message