Posts Tagged ‘10g’

Many people are asking if creating a BPEL process template is possible on 11g.
The answer is NO. Sorry…
It is very annoying as it was possible on 10g.
I guess the reason is because of the way we creates a BPEL process within the composite application.
There is an option to create a project & application template, but not a component one.

In this post I will show one way to send Email notification with attachments.This example will explain how to assign a string message that will appear on the mail as a HTML attachment.In my next post I will explain how to read a file from your OS and send it as an attachment.

Start with creating a new bpel process. Create a new string variable and assign to it the required message that will appear later on in the HTML
(notice that you don’t need to add header/body tags):

In this post I will explain how to add a variable into a XSL code. I will also explain why do we need it at all.
(This option exists on both Oracle SOA Suite 10g and 11g versions. Some of the screens might be a little bit different. Below I’ve attached print screens from 11g)

If you are using a transformation activity in your process, you probably need to do some mapping for multiple records data.
Like in other developing languages, there are cases where you want to declare a variable once, assign to it a value, and use it later on in your code.
When using xsl for mapping source to target, it is the same behavior.

When creating and planning bpel processes, you must always consider using Fault Management.
Bpel process management provides many options and ways to handle and manage fault.
Sometimes, there can be a requirement to throw a custom fault – one that does not exist in the built in system fault that is being provided in the Throw Activity list.
In this post I will describe how to do it, in the most simple way.
I created my example in SOA suite 11g (11.1.1.6), but that’s the way to go on all bpel versions.

DbAdapter provides all kind of operations that helps you interact with the DB.
I saw more than few times, questions, about how to use dynamic parameters when executing the ‘Execute Pure SQL‘ operation.
In the following step I will explain how to do it.

I must say that I’ve predicted this error….
One of my customer’s requirements is to run a simple query on Oracle 10g Database.
I’ve developed a simple process in Bpel 10g that uses ‘select’ operation from a DbAdapter.
I ran the process from the BPELConsole, and got the following error: