Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problem with execute immediately ....( clob variable)
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
![]() |
![]() |