Do not forget that SQL*plus can add extra calls. So try with pl/sql block
or with another tool.
For sql*plus:
begin
for r in (select x.z.o1 a ,x.z.o2 b from (select get_ot z from dual where
rownum>0)x)
loop
dbms_output.put_line(r.a||' - '||r.b);
end loop;
end;
/
--
Best regards,
Sayan Malakshinov
http://orasql.org
