Re: function returning object type and print the attributes
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 18 Jul 2016 17:05:40 +0300
Message-ID: <CAOVevU43JCvgS0MJL0UOJcDNvoPJ6kNgKMag7Uqqv=p-Ry7W5Q_at_mail.gmail.com>
Date: Mon, 18 Jul 2016 17:05:40 +0300
Message-ID: <CAOVevU43JCvgS0MJL0UOJcDNvoPJ6kNgKMag7Uqqv=p-Ry7W5Q_at_mail.gmail.com>
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
Received on Mon Jul 18 2016 - 16:05:40 CEST