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

Apparently my first attempt for a working example to exhibit the error has failed.

Please read http://www.catb.org/~esr/faqs/smart-questions.html

There's nothing wrong with the fragment you posted.

You also might want to crack open the docs.

They are downloadable/viewable from otn.oracle.com.

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



On 2/8/06, Roger Xu <roger_xu_at_dp7uptx.com> wrote:


>

> Nothing wrong with the cursor, the only problem is: "*a_strng := a_ATWRT

> || a_strng;*"

>

> ORA-06502: PL/SQL: numeric or value error

> ORA-06512: at line 97

>

> everything else works fine if I comment out "*a_strng := a_ATWRT ||

> a_strng;*"

>

> Again, the question is "How do I concatenate a string?" I guess := is for

> numeric value only?

>

> Thanks,

>

> Roger

>

> -----Original Message-----

> *From:* Jared Still [mailto:jkstill_at_gmail.com]

> *Sent:* Wednesday, February 08, 2006 3:17 PM

> *To:* Roger Xu

> *Cc:* Oracle-L_at_Freelists. Org (E-mail)

> *Subject:* 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.

> > ____________________________________________________________________

> >

>


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