Feeds:
Posts
Comments

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.

The good news is that it will be possible on 12c version.

You can get help with renaming a BPEL process as a workaround in the below oracle post:
https://blogs.oracle.com/middleware/entry/renaming_bpel_process_names

 

Good luck

Read Full Post »

As promised in my previous post – Adding HTML Attachment To An Email Activity On Bpel 10g, in this post I will explain how to poll a file from the local OS and send it as an attachment.
For my example, I’ve created a simple WORD (.doc) file and put it under my Linux server. 

So here also, create a new Bpel process and drag the Email activity into the process flow. Fill in the required information:

(more…)

Read Full Post »

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):

(more…)

Read Full Post »

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.

Let’s take 2 scenarios:

(more…)

Read Full Post »

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.

(more…)

Read Full Post »

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.

(more…)

Read Full Post »

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:

WSIF JCA Execute of operation ‘GetDataSelect’ failed due to: DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character
]
; nested exception is:
ORABPEL-11614
DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character

(more…)

Read Full Post »

Older Posts »