Re: PL/SQL String Manipulation Problem?

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/29
Message-ID: <57mitt$bkk@newton.pacific.net.sg>#1/1

"Steve Busby" <steve.d.busby_at_scsnet.com> 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 '
>
>

Hi there,

There may be two problems.

Check if you given sufficient data length to your varchar datatype. If your concatenated string is more than data length, then there may be a problem.
If the above solution does not work, change the datatype to VARCHAR2.

In our setup, we use varchar2 setup and it works fine.

Under what OS you are operating your oracle. There may be a known bug in that release.

Regards

N.Prabhakar Received on Fri Nov 29 1996 - 00:00:00 CST