Re: function returning object type and print the attributes

If you enable event 10046 you will see extra FETCH calls in the trace file, which is sqlolus checking if there is any more data to read. That would explain the additional and perhaps unexpected calls.

Stefan

On 18 Jul 2016 9:13 p.m., "Ls Cheng" <exriscer_at_gmail.com> wrote:

> ok, will try that
>
> thanks for the help but the sqlplus extra call is still a mystery for me
> :-)
>
> cheers
>
>
>
> On Mon, Jul 18, 2016 at 4:05 PM, Sayan Malakshinov <xt.and.r_at_gmail.com>
> wrote:
>
>> Just ignore SQL*Plus behaviour with simple SQL, test such queries within
>> p/sql blocks.
>> "select x.z.o1,x.z.o2 from (select get_ot z from dual *where rownum>0*)x"
>> will work fine with Java and any other tools.
>>
>>
>>
>> --
>> Best regards,
>> Sayan Malakshinov
>> Oracle performance tuning engineer
>> Oracle ACE Associate
>> http://orasql.org
>>
>
>

--
http://www.freelists.org/webpage/oracle-l