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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

extract data from Long Raw field

Status
Not open for further replies.

eseabrook2008

Technical User
Jan 9, 2008
74
CA
I have inherited and database (oracle 9i) with a table called "attacheddocuments". In this table is a field called "object" that is of Long Raw type. This field contains files that users have attached (via the front end system). My problem is we are suppose to change to a new system and need to be able to get those files back (that have been saved in the table). The files can be word, excel, pdf, images... I have searched until I'm blue in the face and I don't know where to start.
 

What do you mean by "get those files back"?

You can manipulate and convert to BLOB these "LONG RAW" objects with the DBMS_LOB package, but if you have no way of knowing what's in them (xls, pdf, doc,...) your face may turn from blue to purple.
[3eyes]




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
By "get those files back", I mean extract the data in that field, "recreate" the file and save it to a new location.
 

DBMS_LOB() is what you need.
[noevil]


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top