I already answered this in dbi-users which is where it belongs.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: "Dirk Gomez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 15:07
Subject: multiple updates of CLOBs within a loop
> Has someone an example for this:
>
> (tcl-style code, I'm deeply stuck in TCL at the moment, I'm sorry ;)
>
> set sql_statement "select blob_column,id from table for update"
>
> execute $sql_statement
>
> foreach $row in $sql_statement {
> do_a_regular_expression_replacing on $row's $blob_column
> save $blob_column
> }
>
> I'm on Oracle.
>
> Does it work on DBI?