Re: how do I concatenate a string in PL/SQL?

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_at_dp7uptx.com> 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_at_dp7uptx.com.
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l