[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