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

From: Pat Hildebrand <pat_at_sas.upenn.edu>
Date: Wed, 8 Feb 2006 17:27:59 -0500
Message-ID: <20060208222759.GC1374@sas.upenn.edu>

I common cause of the error that you are getting for strings is that you are trying to put in a value that is too long for the variable. Look at your variable definition and what you are trying to put into it.

Pat

On Wed, Feb 08, 2006 at 05:01:16PM EST, 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
>

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

Received on Wed Feb 08 2006 - 16:27:59 CST