Re: function returning object type and print the attributes
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 18 Jul 2016 16:50:05 +0300
Message-ID: <CAOVevU7JS7shYWfgB8_-i5xhuYTJ90PL0ThghPu+V1qc6Pn2Nw_at_mail.gmail.com>
Date: Mon, 18 Jul 2016 16:50:05 +0300
Message-ID: <CAOVevU7JS7shYWfgB8_-i5xhuYTJ90PL0ThghPu+V1qc6Pn2Nw_at_mail.gmail.com>
As I said before SQL*Plus adds extra calls. I don't know how exactly, but it's always just for first 1 fetch/row.
Compare:
select 0,0 from dual union all
select x.z.o1,x.z.o2 from (select get_ot z from dual)x;
and
select 0,0 from dual union all
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 18 2016 - 15:50:05 CEST