Oracle Fusion Middleware

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

The problem, is that the table and its fields were written in a case sensitive on the DB. The DbAdapter doesn’t really knows how to manage this issue automatically.
In short, to solve this problem, just go to the last screen of the DbAdapter wizard, where you can see the full SQL query, and add inverted commas (“) to the columns.
For example, change the query:

Select Abc, DEfg From ARIK

Into

Select “Abc”, “DEfg” From ARIK

Redeploy and that’s it….