Error: Cannot initiate sort. (State:S1000, Native Code: FFFFFDCA)
Hi,
I have an recursive SPL. After a while i got this error: Error: Cannot initiate
sort. (State:S1000, Native Code: FFFFFDCA)
{ TABLE "vantive".ko_vantbl_rel row size = 555 number of columns = 3 index size
= 102 }
create table "vantive".ko_vantbl_rel
(
kochildtaborvw char(30),
kofkey char(495),
koparenttaborvw char(30)
);
revoke all on "vantive".ko_vantbl_rel from "public";
create index "vantive".i1_ko_vantbl_rel on "vantive".ko_vantbl_rel
(kochildtaborvw);
create index "vantive".i3_ko_vantbl_rel on "vantive".ko_vantbl_rel
(koparenttaborvw);
CREATE PROCEDURE kosp_vantblrel2(parent_id varchar(255))
RETURNING varchar(255);DEFINE child_id varchar(255);
DEFINE level SMALLINT;
DEFINE path, path2 varchar(255);
LET child_id = '';
LET level = 0;
LET path = parent_id;
FOREACH SELECT distinct object.kochildtaborvw
INTO child_id
FROM KO_VANTBL_REL object
WHERE object.koparenttaborvw = parent_id
LET path = parent_id || ' -> ';
IF (child_id != '') and (child_id is not NULL) THEN
LET path2 = '';
FOREACH EXECUTE PROCEDURE kosp_vantblrel2(child_id)
INTO path2
RETURN path || path2 WITH RESUME;
LET level = 1;
END FOREACH;
IF level <> 1 THEN
RETURN path || child_id WITH RESUME;
END IF;
LET level = 0;
LET path2 = '';
END IF;
END FOREACH;
END PROCEDURE;