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

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: roger_xu@xxxxxxxxxxx
  • Date: Wed, 8 Feb 2006 13:16:55 -0800

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

Other related posts: