How to convert BLOB to xml...

, ,
1

Hi All,

Anyone please let me know how to convert BLOB data that we are pulling from a oracle table into a xml file or data.

Thanks in Advance,

Mouli.

2

I am having the same problem…

3

Use SQL developer like tools, save the blob object locally in the file system and rename with .xml extension. You can see the XML version of it… If you are working with Process models, change the extension to .process and import into Designer. You will be able to see the process… Process is nothing but behind the scenes a XML…

HTH
Senthil

4

Hi Senthil .

Thank you for the reply.

What I need to do is store a excel file into de DB for historic purposes.
I then need to be able to get the file from the DB and in the InternetExplorer give it to the client.

Any thoughts?

5

Hi All,

You can try toad for ORacle or DB2 based on the DB you are using. IT gives you the flexibility to pull the Blob as XML data .

Also if you want you can overtide the existing data from a old backup. Depends on which version of toad you are using.

Warm Regards
:idea: S M :idea:

6

wM 6.5 onwards,

Oracle-Specific Enhancements
Support for the Oracle CLOB and BLOB Data Types
The adapter now supports the Oracle-specific CLOB and BLOB data types (java.sql.Clob and java.sql.Blob) as input parameter data types for use in adapter services.

Streaming Support of BLOB and CLOB Data with Oracle Databases
In earlier versions of the adapter, the adapter only supported the byte array and String data types when retrieving BLOB or CLOB fields. However, users sometimes encountered out of memory errors when converting large BLOB data into bytes. This version of the adapter introduces two new data types, java.io.Reader for CLOB and java.io.InputStream for BLOB, to support the streaming of byte data when working with Oracle databases.

So try AdapterService templates built-in and you shoud be able to get to what you need!!!