UTL_FILE.PUTF problem

UTL_FILE.PUTF problem

 

  

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.

Oracle LazyDBA home page