10g | Oracle Fusion Middleware

Posts Tagged ‘10g’

Creating BPEL Template On SOA 11g

Posted in Bpel, JDeveloper, tagged 10g, 11g, 12g, bpel template, JDeveloper, Oracle SOA Suite on November 18, 2013| Leave a Comment »

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 »

Adding A File As An Attachment To An Email Activity On Bpel 10g

Posted in Activities, Bpel, Email, tagged 10g, bpel, email, email activity, JDeveloper, Oracle SOA Suite, SOA on January 21, 2013| Leave a Comment »

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 »

Adding HTML Attachment To An Email Activity On Bpel 10g

Posted in Activities, Bpel, Email, tagged 10g, bpel, email, email activity, JDeveloper, Oracle SOA Suite, SOA on January 15, 2013| Leave a Comment »

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 »

The Use Of Variable In An XSL Code

Posted in Bpel, Development, tagged 10g, 11g, bpel, JDeveloper, Oracle SOA Suite, SOA Suite, transformation activity, xsl on January 10, 2013| Leave a Comment »

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 »

Adding A Custom Fault To A Bpel Process

Posted in Activities, Bpel, Development, tagged 10g, 11g, bpel, fault management, oracle, Oracle SOA Suite, SOA Suite, Throw Activity on November 3, 2012| 4 Comments »

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 »

Using DB Dynamic Parameter – Pure SQL Operation

Posted in Adapters, Bpel, DB Adapter, tagged 10g, 11g, bpel, db, dynamic parameter, JDeveloper, oracle, Oracle SOA Suite, parameter, Pure SQL Operation, SOA on August 1, 2012| 2 Comments »

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 »

Internal Exception: java.sql.SQLException: ORA-00911: invalid character

Posted in Adapters, DB Adapter, tagged 10g, 11g, bpel, bpelconsole, case sensitive, db, JDeveloper, oracle, Oracle SOA Suite, SOA, SQLException on July 8, 2012| Leave a Comment »

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 »

Unable to run JDeveloper – error with jvm.dll

Posted in JDeveloper, tagged 10g, JDeveloper, jvm, SOA Suite on May 27, 2012| 6 Comments »

A few weeks ago I had to change my local PC at one of our customers, after few years of developing with JDeveloper 10.1.3.3 .

Of curse, not everything runs smoothly…

I got an error (which apparently is a very common one) that says:

“unable to create an instance of the java virtual machine located
at path:..\..jdk\jre\bin\client\jvm.dll”

(more…)

Read Full Post »

How To Use Java Embedding Activity – Simple Example

Posted in Activities, Bpel, Java Embedded, tagged 10g, 11g, activity, bpel, java, Java Embedded, oracle, Oracle SOA Suite, SOA on May 17, 2012| Leave a Comment »

The following is a simple example of using Java Embedding Activity in Bpel 11g.
In this example, I used a simple asynch’ process, and assign the input parameter into the output parameter.
To implement this example you have to:

(more…)

Read Full Post »