extract data from Long Raw field

[eseabrook2008]

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.

 

[LKBrwnDBA]

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.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[eseabrook2008]

By "get those files back", I mean extract the data in that field, "recreate" the file and save it to a new location.

 

[LKBrwnDBA]

DBMS_LOB() is what you need.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb