This discussion is archived
1 Reply Latest reply: Jul 2, 2013 1:09 AM by BluShadow RSS

Convert result of query to CLOB

kingjames Newbie
Currently Being Moderated



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?




  • Correct Answers - 10 points
  • Helpful Answers - 5 points