What's your oracle version? Are you sure about 3 calls? Maybe first 2 calls
from previous test?
Best regards,
Sayan Malakshinov
http://orasql.org
On Jul 18, 2016 16:19, "Ls Cheng" <exriscer@xxxxxxxxx> wrote:
ops it's getting worse, the function is now called 3 times instead of 2....
TIA
On Mon, Jul 18, 2016 at 3:17 PM, Sayan Malakshinov <xt.and.r@xxxxxxxxx>
wrote:
Oops, I'm sorry, I've inserted predicate with rownum in the wrong place.
Try like this:
select x.z.o1,x.z.o2 from (select get_ot z from dual where rownum>0)x;
--
Best regards,
Sayan Malakshinov
http://orasql.org
