OraFAQ Forum: SQL & PL/SQL » dbms

Home » SQL & PL/SQL » SQL & PL/SQL » dbms_lob.converttoblob (oracle 9i Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_lob.converttoblob [message #441485]

Mon, 01 February 2010 06:59

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.

Report message to a moderator

Re: dbms_lob.converttoblob [message #441487 is a reply to message #441485]

Mon, 01 February 2010 07:05

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Unfortunatly on this version, you have to write your own program.

Regards
Michel

Report message to a moderator

Re: dbms_lob.converttoblob [message #441490 is a reply to message #441485]

Mon, 01 February 2010 07:08

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: dbms_lob.converttoblob [message #441493 is a reply to message #441490]

Mon, 01 February 2010 07:44

pradeepsakti
Messages: 37
Registered: May 2009

Member

thank you it works though it was not having some parameters as dbms_lob procedure Smile

Report message to a moderator

Previous Topic:	Negative values in LOB
Next Topic:	Databse Objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 26 09:31:37 CDT 2025