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
Certifiable Oracle DBA and Part Time Perl Evangelist
On 2/8/06, Roger Xu <firstname.lastname@example.org> wrote:
Nothing wrong with the cursor, the only problem is: "a_strng := a_ATWRT ||
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line
everything else works fine if I comment out "a_strng := a_ATWRT || a_strng;"
the question is "How do I concatenate a string?" I guess := is for numeric value
-----Original Message-----It is hard to help when we don't know what the
From: Jared Still
Sent: Wednesday, February 08, 2006 3:17
To: Roger Xu
Cc: Oracle-L@Freelists. Org
Subject: Re: how do I concatenate a string in
Try posting a working example that duplicates the
On 2/8/06, Roger Xu
I am a PL/SQL newbie and the following
gives me errors while executing.
a_strng := NULL;
fetch b_cursor into
a_strng := a_ATWRT ||
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