Re: PL/SQL String Manipulation Problem?

Steve Busby wrote:
>
> Has anyone else had problems setting a string equal to itself and
> concatenating another string on the end. Like
>
> strMsg := ' Hello '
> strMsg := strMsg || ' World '
>
> We get a 6502 Oracle error. strMsg is declared as VARCHAR. What am I
> doing wrong, or is this a PL/SQL bug? This is such a common programming
> construct for building long strings, I would think if there is a problem
> someone else would also have had it by now (which leads me to believe it's
> not a bug).

It sounds like your variable strMsg is too small. Try increasing the size to 15 or so.

Jerry.

-- 
----------------------------------------------------
Jerry Bull, Sr. MTS         Phone: 303-624-3073
U S WEST Technologies       Fax:   303-624-8462
931 14th Street, Suite 920  Email: gbbull_at_uswest.com
Denver, CO  80202
----------------------------------------------------