Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Workflow on Oracle database 11g

642003Jun 3 2008 — edited Jun 5 2008
Hi, is Oracle Workflow Server included in 11g?

In this article I read that Oracle has announced product obsolescence for Oracle Workflow and Oracle Workflow Server will not be included in Oracle Database Editions 11g and above.
http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html

In next article I read that Oracle workflow is part of Oracle Warehouse Builder 11g.
http://download.oracle.com/docs/cd/B31080_01/doc/install.102/b28224/install_opts05.htm#i1024473

And finally in this article I read that Oracle Warehouse Builder 11g is now shipped as part of the database and is no longer part of Developer Suite. The core ETL features are now provided free with the database Standard Edition, Standard Edition One, and Enterprise Edition.
http://www.oracle.com/technology/products/warehouse/htdocs/owb_10gr2_faq.htm#IsWarehouseBuilder10gRelease2nowDB

So if OWF is included in OWB and OWB is shipped as a part of database, there must be Workflow included in 11g, am I right?

Thanks
Filip Oliva

Comments

Bill Shannon-Oracle

Let me see if I understand...

You say that the correctly encoded filename "doesn't work". In what sense does it not work?  Exactly what fails and how does it fail?

Are you asking to violate the MIME spec and use more than 75 characters per encoded word?  No, there's no way to force JavaMail to do that.  Are you doing that because your message is being processed by some program that doesn't implement the MIME spec correctly?  Maybe that other program is the thing that needs to be fixed?

user6731020

Thanks Bill for the comments. The issue is if the lengthy encoded word (>75 characters) is passed without including the CRLF spaces then it works fine in Outlook and Gmail but it does not work by sending the lengthy filename using MimeUtility.encodeText() API.


Eg:


//The below code does not work to send the attachment and the attachment name is displaying the UTF-8 characters

String fileName="ÀÁÅÆÀÁÅÆÇÈÉÊËÌÍÎÏÐÀÁÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýþÿÀÁÅÆÇ.doc";

messageBodyPart.setFileName(MimeUtility.encodeText(fileName, "utf-8",null));


//The headers are displayed in Gmail as:

Content-Type: text/plain; name="=?utf-8?B?w4DDgcOFw4bDgMOBw4XDhsOHw4jDicOKw4vDjMONw47Dj8OQw4DDgcOF?="

=?utf-8?B?w4bDh8OIw4nDisOLw4zDjcOOw4/DkMORw5LDk8OUw5XDlsOYw5nDmsObw5w=?=\

\

=?utf-8?B?w53DnsOfw6DDocOiw6PDpMOlw6bDp8Oow6nDqsOrw6zDrcOuw6/DsMOx?=\

\

=?utf-8?B?w7LDs8O0w7XDtsO4w7nDusO7w7zDvcO+w7/DgMOBw4XDhsOHLmRvYw==?="; charset=us-ascii

Content-Transfer-Encoding: 7bit

Content-Disposition: attachment; filename="=?utf-8?B?w4DDgcOFw4bDgMOBw4XDhsOHw4jDicOKw4vDjMONw47Dj8OQw4DDgcOF?=\

\

=?utf-8?B?w4bDh8OIw4nDisOLw4zDjcOOw4/DkMORw5LDk8OUw5XDlsOYw5nDmsObw5w=?=\

\

=?utf-8?B?w53DnsOfw6DDocOiw6PDpMOlw6bDp8Oow6nDqsOrw6zDrcOuw6/DsMOx?=\

\

=?utf-8?B?w7LDs8O0w7XDtsO4w7nDusO7w7zDvcO+w7/DgMOBw4XDhsOHLmRvYw==?="

==============================================

//The below code works and attachment name shows correctly: [Custom generated Base64 code for filename]

String fileName="ÀÁÅÆÀÁÅÆÇÈÉÊËÌÍÎÏÐÀÁÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýþÿÀÁÅÆÇ.doc";

String encodedName = "=?utf-8?B?w4DDgcOFw4bDgMOBw4XDhsOHw4jDicOKw4vDjMONw47Dj8OQw4DDgcOFw4bDh8OIw4nDisOLw4zDjcOOw4/DkMORw5LDk8OUw5XDlsOYw5nDmsObw5zDncOew5/DoMOhw6LDo8Okw6XDpsOnw6jDqcOqw6vDrMOtw67Dr8Oww7HDssOzw7TDtcO2w7jDucO6w7vDvMO9w77Dv8OAw4HDhcOGw4cuZG9j?=";


messageBodyPart.setFileName(encodedName);

//The message header in Gmail:

Content-Type: text/plain; name="=?utf-8?B?w4DDgcOFw4bDgMOBw4XDhsOHw4jDicOKw4vDjMONw47Dj8OQw4DDgcOFw4bDh8OIw4nDisOLw4zDjcOOw4/DkMORw5LDk8OUw5XDlsOYw5nDmsObw5zDncOew5/DoMOhw6LDo8Okw6XDpsOnw6jDqcOqw6vDrMOtw67Dr8Oww7HDssOzw7TDtcO2w7jDucO6w7vDvMO9w77Dv8OAw4HDhcOGw4cuZG9j?="; charset=us-ascii

Content-Transfer-Encoding: 7bit

Content-Disposition: attachment; filename="=?utf-8?B?w4DDgcOFw4bDgMOBw4XDhsOHw4jDicOKw4vDjMONw47Dj8OQw4DDgcOFw4bDh8OIw4nDisOLw4zDjcOOw4/DkMORw5LDk8OUw5XDlsOYw5nDmsObw5zDncOew5/DoMOhw6LDo8Okw6XDpsOnw6jDqcOqw6vDrMOtw67Dr8Oww7HDssOzw7TDtcO2w7jDucO6w7vDvMO9w77Dv8OAw4HDhcOGw4cuZG9j?="

Query - Is it OK to use the above working code?

Bill Shannon-Oracle

Ok, I see the problem.

You shouldn't be encoding the filename yourself using MimeUtility.encodeText because JavaMail will detect it as a parameter value that includes CRLF and will add escapes.  You should just call messageBodyPart.setFileName(fileName).

That will let JavaMail encode the filename itself, using RFC 2231 (assuming you're using the current version of JavaMail).  Or, if the mailers you're using don't support that encoding, you should configure JavaMail to use the non-standard MIME encoding for filenames by setting the System properties "mail.mime.encodefilename" to "true" and "mail.mime.encodeparameters" to "false".

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 3 2008
Added on Jun 3 2008
4 comments
5,542 views