Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> SYS.ANYDATA to BLOB, SYS.ANYDATA to BLOB
manohar reddy g
post Feb 27 2012, 05:48 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 3-January 12
Member No.: 46,518



How to convert a SYS.ANYDATA object to BLOB?

or any user defined type to BLOB?
Go to the top of the page
 
+Quote Post
burleson
post Feb 27 2012, 06:16 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,425
Joined: 26-January 04
Member No.: 13



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!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th August 2014 - 08:26 PM