Home » SQL & PL/SQL » SQL & PL/SQL » dbms_lob.converttoblob (oracle 9i Windows)
dbms_lob.converttoblob [message #441485] Mon, 01 February 2010 06:59 Go to next message
pradeepsakti
Messages: 37
Registered: May 2009
Member

Hello all,

Can any one please tell me is there any substitute for dbms_lob.converttoblob in Oracle 9i. I need to convert a CLOB into BLOB.

Could you pls help??

Thanks ,
Pradeep.
Re: dbms_lob.converttoblob [message #441487 is a reply to message #441485] Mon, 01 February 2010 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unfortunatly on this version, you have to write your own program.

Regards
Michel
Re: dbms_lob.converttoblob [message #441490 is a reply to message #441485] Mon, 01 February 2010 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's an example of what you can do:
http://kr.forums.oracle.com/forums/thread.jspa?messageID=2702149

Regards
Michel
Re: dbms_lob.converttoblob [message #441493 is a reply to message #441490] Mon, 01 February 2010 07:44 Go to previous message
pradeepsakti
Messages: 37
Registered: May 2009
Member

thank you it works though it was not having some parameters as dbms_lob procedure Smile
Previous Topic: Negative values in LOB
Next Topic: Databse Objects
Goto Forum:
  


Current Time: Sat Oct 01 04:07:25 CDT 2016

Total time taken to generate the page: 0.11994 seconds