Hi

I am using

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

SELECT A.col1,A.col2
FROM my table A
CONNECT BY PRIOR A.col1 = A.parentcol1
AND A.myowndate=
func_inline(a.col1,'03/08/2001')
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'

Rgds