Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem with execute immediately ....( clob variable)

Problem with execute immediately ....( clob variable)

From: George D. Benetos <gbene_at_intrasoft.gr>
Date: Mon, 17 Jan 2000 11:06:25 +0200
Message-ID: <85um3u$gk5$1@foo.grnet.gr> 





Hello ,


Here is the problem.


There is an command I used "EXECUTE IMMEDIATETELY MAINSQL"
where mainsql is a string which can not be represented neither as an
varchar2 nor as long variable , due to the size of the string (over 32000  ,
which is the limit for a long variable).
I tried to solve the problem  using  the "clob " datatype for
mainsql,but there is an error message about "inconsistent datatypes" .
Is there any idea ?


Thank you .....


Received on Mon Jan 17 2000 - 03:06:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US