Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can you help with a CLOB problem?

Re: Can you help with a CLOB problem?

From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 29 Mar 2007 14:53:21 +0100
Message-ID: <MPG.2075e33864d6716898a40b@news.individual.net>


In article <1175178716.990174.24100_at_p15g2000hsd.googlegroups.com>, frank.van.bortel_at_gmail.com says...
> On 29 mrt, 10:06, Jeremy <jeremy0..._at_gmail.com> wrote:

<snip>

> > 10286 l_fab_form.view_form_score_intro :=
> > 10287 replace (l_fab_form.view_form_score_intro,'[score]',p_score);

<snip>

>
> Just a thought: what if the replaced string exceeds 4000 characters?
>

Hi, that's a good point. In practical terms there is no need for these strings to exceed that length but we ought to add a safeguard.

Re the original problem - it was of course so incredibly simple. We were passing NULL into the "append" functions' p_in parameter.....

-- 
jeremy
Received on Thu Mar 29 2007 - 08:53:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US