Guest_imported
New member
- Jan 1, 1970
- 0
I have a CFQUERY that looks like this:
INSERT INTO TABLE_TEXT (NODE_ID,
GENERATED_TIME_PERIOD, TEXT_ID, TEXT)
VALUES ('#nodeID#', '#academicyear#',
'OVERVIEW', '#s1#'||'#s2#'||'#s3#'||'#s4#')
which basically concatenates a fixed number of strings to be sent into a long datatype column in an oracle table. This works just fine if my datasource is set up to be an ODBC. However I've changed my application setting so it connects natively.
This is the error I'm getting:
Oracle Error Code = 1489<P>ORA-01489: result of string concatenation is too long
<P><P> <P><p>The error occurred while processing an element with a general identifier of (CFQUERY),
Is there any way to work around the code so that the query would work the same way with the native driver as it does with an ODBC connection? Any help would be GREATLY appreciated.
INSERT INTO TABLE_TEXT (NODE_ID,
GENERATED_TIME_PERIOD, TEXT_ID, TEXT)
VALUES ('#nodeID#', '#academicyear#',
'OVERVIEW', '#s1#'||'#s2#'||'#s3#'||'#s4#')
which basically concatenates a fixed number of strings to be sent into a long datatype column in an oracle table. This works just fine if my datasource is set up to be an ODBC. However I've changed my application setting so it connects natively.
This is the error I'm getting:
Oracle Error Code = 1489<P>ORA-01489: result of string concatenation is too long
<P><P> <P><p>The error occurred while processing an element with a general identifier of (CFQUERY),
Is there any way to work around the code so that the query would work the same way with the native driver as it does with an ODBC connection? Any help would be GREATLY appreciated.