Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how do I concatenate a string in PL/SQL?
Roger,
We can't help if you don't give us enough info.
:= is NOT just for numeric value. || is the correct concatentation operator.
Here is my proof:
SQL> set serveroutput on
SQL> declare
2 a_strng varchar2(5); 3 b_strng varchar2(5); 4 c_strng varchar2(10);
6 a_strng := 'Hello'; 7 b_strng := 'World'; 8 c_strng := a_strng || b_strng;
PL/SQL procedure successfully completed.
SQL> select * from v$version;
BANNER
Now, show us your (complete) test case.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and those who don't."
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Wednesday, February 08, 2006 5:01 PM
To: Jared Still
Cc: Oracle-L_at_Freelists. Org (E-mail)
Subject: RE: how do I concatenate a string in PL/SQL?
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<mailto: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 entityto 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 MessageLabsEmail 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 08 2006 - 16:20:26 CST
![]() |
![]() |