Problem with SYS_CONNECT_BY_PATH i SPL

Version 11.50.FC7 I am using a SELECT SYS_CONNECT_BY_PATH in a foreach in a stored procedure. SELECT SYS_CONNECT_BY_PATH( id,'/')||'/' as platspath INTO variable FROM plats START WITH id = 1407 CONNECT BY PRIOR parent_id=id ORDER BY level DESC; If I run the SPL I get a -1214, SMALLINT exceeds 32000. There is no smallints among the variables I use, I have reduced it to be only one varchar(100). If I run the select by itself it works fine. Any ideas ? Ulf

Just found the following bug report IC77736: CONNECT BY (HIERARCHICAL) QUERY EXECUTED WITHIN STORED PROCEDURE CAN LEAD TO ERROR 1214 This is not fixed yet, guess I have to find another way to solve the problem Ulf