Re: Append VARCHAR to LONG data type in PL/SQL

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 09 Apr 2003 22:17:56 +0200
Message-ID: <ktv89volp6k7989ugcaajld1fgst9uelef_at_4ax.com>


On 9 Apr 2003 10:21:17 -0700, dansanders_at_att.net (Dan) wrote:

>I am trying to find a way to append a string to the end of a LONG data
>type in pl/sql.
>
>Any suggestions?

Stop using longs. They are obsolete and deprecated, and will likely disappear from the next major release.
Convert to CLOB and use the dbms_lob package which has all the facilities

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 09 2003 - 22:17:56 CEST

Original text of this message