var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 80 character limitation on VARCHAR variable
I have this code:
DECLARE v_insert VARCHAR(255);
SET v_insert = 'INSERT INTO mytable (field1, field2, field3, field4, field5, field6, field7, field8 field9)';
SET v_insert = v_insert || ' Select * from sometable';
EXECUTE IMMEDIATE v_insert;
Problem is the v_insert variable only holds 80 characters. The first assignment statement has more than 80 so it cuts it off. I tried 1000 in the varchar declaration.
Is there another variable to use or is there a reason I'm limited to 80 characters?
How do you determine that "the v_insert variable only holds 80 characters"?
80 char limit
In the Development Center debug window. I was wondering if it's a problem with the debug window so I am trying to put the string out to a table right now.
80 character limit
Thanks for the lead n_i, when I inserted the data into a table I could see the full string. I just assumed the debugger was showing me the correct value.