Layer7 API Management

  • Private Community

  • 1.  Insert clob data with "perform jdbc query assertion"

    Posted Oct 05, 2017 08:24 AM

    Hello,

    any advise on how to insert a big "700 K" text field into a Oracle CLOB with perform jdbc query assertion or other better alternatives?

     

    Thanks



  • 2.  Re: Insert clob data with "perform jdbc query assertion"
    Best Answer

    Broadcom Employee
    Posted Nov 23, 2018 05:15 PM

    A case was created for this question and the response was:

     

    Any functions and procedures in Oracle that return NCLOBs or NBLOBs with values greater than 32KB cannot be called from the CA API Gateway as per the doc.

    https://docops.ca.com/ca-api-gateway/9-1/en/policy-assertions/assertion-palette/access-control-assertions/perform-jdbc-query-assertion/

     

    An IDEA will need to be created in the community with this feature request.

     

    Sincerely,

     

    Stephen Hughes

    Broadcom Support