SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert base64 encoded clob into a blob

Mark ReichmanOct 20 2006 — edited May 30 2007

Im hearing crickets in the xml db forum.. So..

Does anybody have an example of a procedure that converts a base64 encoded clob into a blob on a 9.0.2 database. Preferably exhibiting a clob that is in the megabyte range? I would also prefer a plsql solution using utl_encode.base64_decode? If I have to, I'll break down and use java, but would rather do it with PL/SQL.

Thanks.. I must be the only person on the planet that wants to do this because google is empty..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 11 2007

Added on Oct 20 2006

6 comments

6,520 views