Are you fetching inside the loop?

>>> "Michael Lysenko "
<oracledba-ezmlmshield-x71658227.[Email address protected] 8/2/2006
12:54:42 >>>
Hi all,


I have some pl\sql code which should put cursor's data into file.
Cursor select 10 rows from table but when i am trying to put cursor's
data to file (UTL_FILE.PUTF) then it prints only 1st row into file, if
to use LOOP then it prints multiple copies of this 1st raw. I know that
cursor contains 10 unique rows.

Any ideas?


M.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page