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

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,

Legend

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