never had to build a LOB in that way. Are you trying to combine
multiple columns or somthing?
-Adam
----- Original Message -----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 11:34:32 -0400
Subject: RE: OT: Oracle 9i
To: CF-Talk <[EMAIL PROTECTED]>
I have not, will this increase the performance? I read that clobs could be
used the same as varchars so I didn't think I would have to.
Thanks,
David
-----Original Message-----
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 11:23 AM
To: CF-Talk
Subject: Re: OT: Oracle 9i
Have you tried using the DBMS_LOB.Append function?
-Adam
----- Original Message -----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 11:16:02 -0400
Subject: OT: Oracle 9i
To: CF-Talk <[EMAIL PROTECTED]>
If I have am building an extremely large string (40,000 chars) in a PL/SQL
stored procedure. Would it be better to keep concatenating a variable of
a
CLOB datatype? Or build 10 varchars and concatenate them at the end into
a
CLOB?
I have noticed that my stored procedure runs very slow using the clob. if
I
use a single varchar(4000) the procedure runs very fast. If I limit the
data
to 4000 chars and do the same with a clob it runs very slow.
The way I am doing this is concat(ClobString, 'some more text') over and
over and over again. Slow....
Thanks,
David________________________________________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
