Slow execution when calling function from select

Hello,

I have a query that returns 1 row and runs in 1s.

select a,b,c,d from t1 where condition N

A       B        C        D
Test   10      14       AB

I have a function that receives 2 parameters and executes in less than a second.

select myFunc(14,'AB') from dual

When I combine the two together it takes over 30s to run.

select a,b,myFunc(c,d) from t1 where condition N

Any help would be appreciated. Received on Thu May 25 2006 - 13:05:14 CDT