1 Reply Latest reply: Jul 2, 2013 3:09 AM by BluShadow RSS

    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?