Not on 10g yet and need CLOB2BLOB or BLOB2CLOB conversion ?

Noticed that on 10g there is functionality for CLOB to BLOB and BLOB to CLOB converson. Problem is that we are a few months away still from being on 10g. So whats a 9iR2 guy supposed to do... write your own.

Here are two handy functions you can use.. not sure what the max size conversions is but I would assume whatever LOB size max is.. so 4 GB for now ? and in 10g+ ... Terrabytes.

Pages: 1· 2