In the script activity I defined a variable (string length>255):
vars.cmpdeliveries = myVar123; //myVar123 is a string with more than 255 characters
In the query activity, where I define the recipients, I add the variable above using 'complementary information' (also tried with enrichment activity, but end up with the same error).
When running the workflow I get an error:
ORA-210000 Oracle error: ORA-12899: value too large for column "CAMUSER"."WKF28138905_32_1"."SCMPDELIVERIES" (actual: 780, maximum: 255)...
The goal is to use the variable (targetData.cmpdeliveries) in a delivery (continuous delivery activity in the same workflow). It works if the variable has less than 255 characters. Any solution for string >255 characters?
Thank you! I marked this as the correct answer because it solved my issue. But with this solution I can't use "Continuous Delivery" because the activity doesn't have a "Script" tab. I use now multiple "Delivery" activities instead and this works. If somebody knows a solution for "Continuous Delivery" activity feel free to post.
If I understand you correctly your solution implies to store the value of the variable into a field (of type CDATA or MEMO) of the recipient table. But I don't want to store the data in the database. All I want to do is to enrich the query/temporary-schema with the value of the variable, in order to use it in the delivery.
This is my workflow:
Query activity (Complementary information):
This activity fails if length(vars.mytestvar)>255; I don't want to store it in the DB.
How to define datatype CDATA or Memo? Do you have a sample? Is there any documentation?