[Deploying Sakai] 2.5 -> 2.6 SQL conversion scripts and Oracle 9i
Seth Theriault
slt at columbia.edu
Thu Jul 22 16:41:23 PDT 2010
Matthew Jones wrote:
> C. Writing a command line script in your favorite scripting
> language to check every XML column in that table and replace
> these fields in the XML blob.
In the end, a Perl script did the trick. It reads the old data,
makes the substitution, and writes back the corrected data using
bind variables to deal the XML column's CLOBiness.
Seth
More information about the production
mailing list