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.

And what happens to be that condition? And what happens
to be the query plan? And how many rows happen to be in
the table? In other words, give us a worked example.
Sorry, my crystal ball needs cleaning...

--
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com