Problem with execute immediately
From: George D. Benetos <gbene_at_intrasoft.gr>
Date: Mon, 17 Jan 2000 11:09:07 +0200
Message-ID: <85um90$gke$1_at_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 - 10:09:07 CET
Date: Mon, 17 Jan 2000 11:09:07 +0200
Message-ID: <85um90$gke$1_at_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 - 10:09:07 CET