Oracle BPEL Database Adapater - Passing the whole SQL itself as Parameter to DBAdapter
Hi
I need to create a BPEL process in such a way that whole sql Query should be a paramater. How to acheive this scenario? Is that possible using DB Adapater in BPEL 11g?
Scenario
I have a select query "select * from tablename" . this query should be passed to db adapter using an assign activity.
What Operation type i need to use
* call a stored procedure or function
* Perform an operation on table
Insert Or update
insert only
Update only
delete
select
Query by example
* Poll for new or changed records in a table.
* execute pure sql
0