BLOB

[mheilbut]

Hi everyone!

I am using a table named SW_ATTACHMENT which contains a BLOB in one of the columns. I have to read this attachment and see if it is a .doc format and if so return 1, else 0.
Anyone know how I can do this? Can I use dbms.instr?
I am using Peoplesoft Vantive and Oracle.

Thanx in advance.
If I wasn't clear enough in the explanation please tell me so. Thanx again.

Michel, São Paulo, Brazil

 

[npraju1]

Have you got the attachments extracted from sw_attachment table?

if so could please share with me how you did it

Regards
Raju