I am using

Oracle8i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

SELECT A.col1,A.col2
FROM my table A
CONNECT BY PRIOR A.col1 = A.parentcol1
AND A.myowndate=
START WITH a.col1 = 'ST001'

The above 'connect by query' calls an func_inline which return some date based on the a.col1 !! the problem is the query hangs !!! but if i pass an paramter and execute the function indepently (func_inline) it return the values..

is there is any problem having an inline functions for 'connect by clause'