1 Reply Latest reply on Jul 2, 2013 8:09 AM by BluShadow

    Convert result of query to CLOB

    kingjames

      Hi,

       

      I have a query which is  'execute immediate vc_query into vcl_result'.  Here vc_query is a varchar2 which is holding my query and return some value, And vc_result is a CLOB.

       

      Now, this statement is failing to execute and saying inconsistent datatypes.

       

      Is there a way I can convert the result of the sql query in the variable to convert to clob?

       

      Thanks,