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