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