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

    Convert result of query to CLOB




      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?