It is hard to help when we don't know what the errors are. Try posting a working example that duplicates the error. On 2/8/06, Roger Xu <roger_xu@xxxxxxxxxxx> wrote: > > I am a PL/SQL newbie and the following gives me errors while executing. > > a_strng := NULL; > open b_cursor; > loop > fetch b_cursor into a_ATWRT; > *a_strng := a_ATWRT || a_strng; > * exit when b_cursor%NOTFOUND; > end loop; > close b_cursor; > > Thanks, > > Roger > > This e-mail is intended solely for the person or entity to which it is > addressed and may contain confidential and/or privileged information. Any > review, dissemination, copying, printing or other use of this e-mail by > persons or entities other than the addressee is prohibited. If you have > received this e-mail in error, please contact the sender immediately and > delete the material. > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email > Security System. Any questions please call 972-721-8257 or email your > request to tech_support@xxxxxxxxxxxx > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist