Re: inconsistency between sql and pl/sql

There is no inconsistency.
You make implicit fetches in loop statement, and then explicit fetches.
You print only explicit fetches results, implicit ones are lost.
Try as below
tedchyn_at_yahoo.com wrote in article <7u4r4n$n3t$1_at_nnrp1.deja.com>...
: Sir, why am I getting this inconsistency between sql and pl/sql for
: identical sql statement (sql 10 rows and pl/sql 5 rows).
: 2 cursor cur1 is select to_char(odate,'yyyy-mon') v_date from
c_order
: 3 group by to_char(odate,'yyyy-mon') ;
: 4 begin
: 5 for rec in cur1 loop
: 7 dbms_output.put_line(rec.v_date);
: 8 end loop;
: 9 end;
: 10 /

--
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

• Bank "Grant", Kharkov, Ukraine