Re: function returning object type and print the attributes

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