I have an Oracle database that has a couple of BLOB columns. The data was written to that column with a client application developed in Powerbuilder (a language that I know nothing about). The data stored in that BLOB is text, along with some control characters. When you see the data through the Powerbuilder client, it essentially looks like a Word doc.

I am in the middle of a migration effort, and the requirement is to dump those BLOB records into Word docs, so that we can load those Word docs into a document management system. (If not Word, then print them into a PDF file.)

So, I have a few questions:
1 - How can I write a script to read those BLOB records? I know nothing of Powerbuilder, but I'm guessing I'm going to need some sort of Powerbuilder interface to get to that data? Does Powerbuilder use some Java class that I can make use of?

2 - Once I've read that data (text and control characters), how can I convert/save that into a word doc?

Thanks, Tom