Yes
----- Original Message -----
From: "Rick Lemons "
<oracledba-ezmlmshield-x9441321.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 02, 2006 9:13 PM
Subject: Re: UTL_FILE.PUTF problem


> 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
>
>
>
> --------
> 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