Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can you help with a CLOB problem?
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.....
-- jeremyReceived on Thu Mar 29 2007 - 08:53:21 CDT