SYS.ANYDATA to BLOB, SYS.ANYDATA to BLOB Options

[manohar reddy g]

How to convert a SYS.ANYDATA object to BLOB?

or any user defined type to BLOB?

[burleson]

Hi Manohar,

>> How to convert a SYS.ANYDATA object to BLOB?

good question!

Read up on dbms_lob.converttoblob

http://docs.oracle.com/cd/B19306_01/appdev...ob.htm#i1020355

I've never done it before, but I would try this first:

1 - Use utl_raw.cast_to_raw to convert to a raw datatype

2 - Input the raw into the dbms_lob.converttoblob function and see if it goes into a BLOB datatype

Here is a working example of converting to a blob:

http://www.dba-oracle.com/t_convert_to_blob_datatype.htm

Let me know if this works!