-
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
Vijay.s
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|