Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LongRaw and BLOB

Status
Not open for further replies.

devone

Technical User
Nov 2, 2000
2
US
Hi,
I have a LongRaw column in one of my tables in oracle 8.0.6 DB..
It stores huge doc. (upto 1 MB)... I need to move this DATa into another table with a BLOB Column.. I'm trying to find the best possible way to do it ...
Any Ideas ?
 
As far as I am aware this is not possible to do this in ORACLE until 8.1.6 which has a to blob function.

We have done this once before using Word, where the word document was held in the long raw. This was put into Word and then taken from Word back into a BLOB. This was driven from an Oracle Form.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top