I'm hoping someone can help me here. I'm trying to start a BPEL process via email. The email can consist of no attachments or multiple attachments. All the attachments should be text, e.g. XML, CSV, etc.
Where I have got to is receiving the email and writing the attachments to variables. All is fine until I get an attachment that has a MIME type of application/octet-stream. I would only expect to see this for files that are not text based.
Does anyon know how I can inturpret this type so I can extract the text? In this example both files are text based although only the first file is displayed.
<?xml version="1.0" encoding="UTF-8" ?>
- <mailMessage xmlns="http://services.oracle.com/bpel/mail">
- <from>
<email>james@james.com</email>
<displayName>James</displayName>
</from>
- <to>
- <address>
<email>j@james</email>
<displayName>James</displayName>
</address>
</to>
- <replyTo>
<email>james@james.com</email>
<displayName>James</displayName>
</replyTo>
<subject>RE: test</subject>
<sentDate>2007-05-02T11:19:37.000+12:00</sentDate>
<contentType>multipart/mixed; boundary="----_=_NextPart_001_01C78C47.6040C3F0"</contentType>
- <content>
- <multiPart>
- <bodyPart>
<contentType>text/plain; charset="iso-8859-1"</contentType>
<content>________________________________ From: James [mailto:j@james.com] Sent: Tue 1/05/2007 3:05 PM To: James Subject: test</content>
</bodyPart>
- <bodyPart>
<contentType>text/plain; name="create_MODS_schema.sql"</contentType>
<content>CREATE USER TOLLBPEL IDENTIFIED BY VALUES 'TOLLBPEL' DEFAULT TABLESPACE APPS_TS_MODS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT ANALYZE ANY TO MODS; GRANT CREATE TYPE TO MODS; GRANT CREATE TABLE TO MODS; GRANT ALTER SESSION TO MODS; GRANT QUERY REWRITE TO MODS; GRANT CREATE CLUSTER TO MODS; GRANT CREATE SESSION TO MODS; GRANT CREATE TRIGGER TO MODS; GRANT CREATE SEQUENCE TO MODS; GRANT CREATE SNAPSHOT TO MODS; GRANT DROP ANY OUTLINE TO MODS; GRANT ALTER ANY OUTLINE TO MODS; GRANT CREATE ANY OUTLINE TO MODS; GRANT CREATE DATABASE LINK TO MODS; GRANT CREATE PROCEDURE to MODS; ALTER USER MODS QUOTA UNLIMITED ON APPS_TS_MODS_DATA; ALTER USER MODS QUOTA UNLIMITED ON APPS_TS_MODS_IDX;</content>
<bodyPartName>create_MODS_schema.sql</bodyPartName>
</bodyPart>
- <bodyPart>
<contentType>application/octet-stream; name="citup.log"</contentType>
<content>W0luc3RhbGxTaGllbGQgU2lsZW50XQ0KVmVyc2lvbj12NS4wMC4wMDANCkZpbGU9TG9nIEZpbGUNCltSZXNwb25zZVJlc3VsdF0NClJlc3VsdENvZGU9LTEyDQo=</content>
</bodyPart>
</multiPart>
</content>
</mailMessage>
Any help will be appreciated.
cheers
James