Hi,
I want to create a procedures with over 1200 lines but I get this error Communication link failure. SQLSTATE 40003.
In the procedure I have a cursor with a CASE expression with over 180 WHEN conditions. If I try to create this procedure step by step - first to create with only 10 WHEN conditions then with 20 and so on it is ok but if I want to create first time with all 180 WHEN conditions give me this error.
I have to set some configurations paramaters?
Thanks
I want to create a procedures with over 1200 lines but I get this error Communication link failure. SQLSTATE 40003.
In the procedure I have a cursor with a CASE expression with over 180 WHEN conditions. If I try to create this procedure step by step - first to create with only 10 WHEN conditions then with 20 and so on it is ok but if I want to create first time with all 180 WHEN conditions give me this error.
I have to set some configurations paramaters?
Thanks