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

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Wed, 8 Feb 2006 16:01:16 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7051839A4@irv2kexch01.tx.bg.corp>

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 < <mailto:roger_xu_at_dp7uptx.com> 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

For technical support please email tech_support_at_dp7uptx.com or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email Security System.



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.
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 08 2006 - 16:01:16 CST